关于一个复杂的查询问题

[hpamweeq53]

SQL代码求助
AA BB CC
1 2006-6-28 1
1 2006-6-29 2
1 2006-6-30 3
1 2006-7-1 4
1 2006-7-2 3
1 2006-7-3 2
1 2006-7-4 1
2 2006-6-28 1
2 2006-6-29 2
2 2006-6-30 3
2 2006-7-1 4
2 2006-7-2 3
2 2006-7-3 2
2 2006-7-4 1

原表为这样AA ,BB,CC为列
想得到结果为

AA，BB值为列CC值为值

AA 2006-6-28 2006-6-29 2006-6-30 2006-7-1 2006-7-2

1 1 2 3 4 3

2 1 2 3 4 3

[LouisXIV]

declare @sql varchar(8000)
select @sql=''
select @sql=@sql+',sum(case when BB='''+BB+''' then CC else 0 end )as ['+BB+']' from TableName group by BB
select @sql='select AA'+@sql+' from TableName Group by AA'

[liangpei2008]

经典的行转列问题