Код: Выделить всё
CREATE VIEW otrs
AS
SELECT cast([***] as int)
,cast([***] as varchar(max))
,cast([***] as varchar(32))
,cast[***] as varchar(max))
,cast([***] as varchar(max))
,cast([***] as varchar(32))
,cast([***] as varchar(max))
,cast([***] as varchar(32))
,STUFF((SELECT ' '+ *** +',' FROM dbo.*** TT WHERE TT.***=T.*** FOR XML PATH('')),1,1,'')
FROM dbo.***
GROUP BY ***, ***, ***, ***, ***, ***, ***, ***