这种条件用sqlserver如何写

这种条件用sqlserver怎么写
AA BB CC --字段名
1 a A 
1 a B  
1 b A 
1 b C 
2 a C
2 a B
变成
AA A B C
1 a a
1 b - b
2 - a a


[解决办法]

SQL code

declare @t table (AA int,BB varchar(1),CC varchar(1))insert into @tselect 1,'a','A' union allselect 1,'a','B' union allselect 1,'b','A' union allselect 1,'b','C' union allselect 2,'a','C' union allselect 2,'a','B'SELECT * FROM @tSELECT AA,a=ISNULL(a,'-'),b=ISNULL(b,'-'),c=ISNULL(c,'-') FROM(SELECT *,dd=bb FROM @t) aPIVOT(MAX(dd) FOR CC IN ([A],[B],[C])) bORDER BY AA/*AA    a    b    c1    a    a    -1    b    -    b2    -    a    a*/