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*/