sqlserver 合并行

表aaaaa

-------------------------

d                                    f

--------------------------------------------------

001                             111

001                             222

001                             333

002                             11

002                             22

003                             33

----

查询语句：

SELECT d,data=STUFF((SELECT ','+[e] FROM aaaaa t where d=t1.d For Xml path('')), 1, 1, '')
FROM aaaaa t1
GROUP BY d

结果：

d          data

001    111,222,333
002    11,22
003    33