行转列？
表A
a b
-------------
aa1
aa2
aa3
aa4
aa5
aa6
bb1
bb2
bb3
bb4
bb5
bb6

得到结果：
a b
-------------
a a1,a2,a3,a4,a5,a6
b b1,b2,b3,b4,b5,b6

语句实现，谢谢！

[解决办法]

USE test
GO



--if object_id('表A') is not null 
--drop table [表A]
--Go
--Create table [表A]([a] nvarchar(1),[b] nvarchar(2))
--Insert into [表A]
--Select N'a',N'a1'
--Union all Select N'a',N'a2'
--Union all Select N'a',N'a3'
--Union all Select N'a',N'a4'
--Union all Select N'a',N'a5'
--Union all Select N'a',N'a6'
--Union all Select N'b',N'b1'
--Union all Select N'b',N'b2'
--Union all Select N'b',N'b3'
--Union all Select N'b',N'b4'
--Union all Select N'b',N'b5'
--Union all Select N'b',N'b6'


select a,stuff((select ','+b from 表A where a=a.a order by b for xml path('')),1,1,'') as b 
from 表A as a 
group by a

/*
a    b
---- ------------------
a    a1,a2,a3,a4,a5,a6
b    b1,b2,b3,b4,b5,b6
*/