SQL结果集转换--附多行转为一列

如下图将结果集1(图1)转换为结果集2(图2)

 

ID          name                 value
----------- -------------------- ----------
1           张三                   aaa
2           张三                   ssss
3           张三                   ddd
4           张三                   fff
5           李四                   ggg
6           李四                   hhhh
7           李四                   jjj
8           李四                   kkk
9           李四                   ll

              

              图1

 

name                 Two
-------------------- ---------------------------

李四                   ggg,hhhh,jjj,kkk,ll
张三                   aaa,ssss,ddd,fff

              图2

 

SQL语句：

   use City; go SET NOCOUNT ON if OBJECT_ID(N'A',N'U') is not null drop table A go create table A ( ID int identity(1,1) p