参考:
https://www.cnblogs.com/no27/p/6398130.html
SELECT 分组列 , value = ( STUFF(( SELECT distinct ',' + 转行的列
FROM 表
WHERE 分组列 = a.分组列
FOR
XML PATH('')
), 1, 1, '') )
FROM 表 a
GROUP BY 分组列