问Sql -通过游标将字段w/多行组合成一个字段

EN

with T(ID, Product) as 
(
select 1,              'Survey' union all
select 1,              'Policy' union all
select 1,              'Invoice' union all
select 2,              'Invoice' union all
select 2,              'Survey' union all
select 3,              'Policy' union all
select 3,              'Invoice'
)

select
  T1.ID,
  stuff((select ', '+T2.Product
         from T as T2 
         where T1.ID = T2.ID
         for xml path(''), type).value('.', 'nvarchar(max)'), 1, 2, '') as Product
from T as T1
group by T1.ID

DECLARE @tbl AS TABLE (ID int, Product VARCHAR(50))

INSERT INTO @tbl VALUES (
 1              ,'Survey'),
( 1              ,'Policy'),
( 1              ,'Invoice'),
( 2              ,'Invoice'),
( 2              ,'Survey'),
( 3              ,'Policy'),
( 3              ,'Invoice')

;WITH IDs AS (
SELECT ID
FROM @tbl
GROUP BY ID
)
SELECT IDs.ID, STUFF(Products.Products, 1, 1, '')
FROM IDs
OUTER APPLY (
SELECT ',' + Product
FROM @tbl AS tbl
WHERE ID = IDs.ID
FOR XML PATH ('')
) AS Products (Products)