分类：
2008-06-27 09:29:33
insert into aaa
values('张三', '英语', 78)
insert into aaa
values('张三', 'C', 97)
insert into aaa
values('里四', '数学', 50)
insert into aaa
values('里四', '英语', 78)
insert into aaa
values('里四', 'C', 77)
select * from aaa
declare @sql varchar(4000)
set @sql = 'select Name'
select @sql = @sql + ',sum(case courseName when '''+courseName+''' then score end) ['+courseName+']'
from (select distinct courseName from aaa) as a
select @sql = @sql+' from aaa group by name'
print @sql
exec(@sql)
