declare @s varchar(3000)
select distinct 科目 into #t from 学生考试信息表
set @s = 'select 姓名'
select @s = @s + ',sum(case when 科目 ='''+ 科目 + ''' then 分数 else 0 end) as [' +科目+']' from #t order by 科目
set @s = @s + ' from 学生考试信息表 group by 姓名'
drop table #t
exec (@s)
---通过 谢谢
declare @sql varchar(8000)
set @sql = 'select '
select @sql = @sql + 'sum(case a when '''+a+'''
then b else 0 end) '+a+'的数量,'
from (select distinct a from #) as a
declare @s varchar(3000)
select distinct 科目 into #t from table1
set @s = 'select 姓名'
select @s = @s + ',sum(case when 科目 ='''+ 科目 + ''' then 分数 else 0 end) as [' +科目+']' from #t order by 科目
set @s = @s + ' from talbe1 group by 姓名'
exec (@s)
declare @sql varchar(8000)
set @sql = 'select 姓名'
select @sql = @sql + ',sum(case 科目 when '''+科目+''' then 分数 end) ['+科目+']'
from (select distinct 科目 from 学生考试信息表) as a
select @sql = @sql+' from 学生考试信息表 group by 姓名'