行列转换

Declare @sql varchar(4000)
set @sql = 'select 姓名'
select @sql = @sql +
',sum(case type when '''+课程+''' then Point else 0 end) as '+课程+''
from (select distinct 课程 from 信息表) as NewTable
select @sql = @sql+' from 信息表 group by 姓名 order by 姓名 asc'
select @sql
exec (@sql)