SQL Server 2005 合并字段写法

select id, [value] = stuff((select ',' + [value] from tb where id = t.id for xml path('')) , 1 , 1 , '')
from tb t
group by id


1   a
1   b
1   c
1   d
2   a
2   b
2   d

结果：
1    a,b,c,d
2    a,b,d