就是想把以下查询的结果放入一张虚拟表中,请问怎么实现呢?
declare @sql varchar(1000)
set @sql = 'select StudentCode'
select @sql = @sql + ',sum(case CourseName when '''+CourseName+''' then ExamScore else 0 end)
['+CourseName+']'
from (select distinct CourseName from #temp_score) as a
set @sql = @sql + 'from #temp_score group by StudentCode'
exec(@sql)
declare @sql varchar(1000)
set @sql = 'select StudentCode'
select @sql = @sql + ',sum(case CourseName when '''+CourseName+''' then ExamScore else 0 end)
['+CourseName+']'
from (select distinct CourseName from #temp_score) as a
set @sql = @sql + 'from #temp_score group by StudentCode'
exec(@sql)
set @sql = 'select StudentCode '
select @sql = @sql + ',sum(case CourseName when ' ' '+CourseName+ ' ' ' then ExamScore else 0 end)
[ '+CourseName+ '] '
from (select distinct CourseName from #temp_score) as a
set @sql = @sql + ' into #t from #temp_score group by StudentCode '
exec(@sql)
declare @sql varchar(1000)
set @sql = 'select StudentCode '
select @sql = @sql + ',sum(case CourseName when ' ' '+CourseName+ ' ' ' then ExamScore else 0 end)
[ '+CourseName+ '] '
from (select distinct CourseName from #temp_score) as a
set @sql = @sql + ' from #temp_score group by StudentCode 'insert #t
exec(@sql)
set @sql = 'select StudentCode '
select @sql = @sql + ',sum(case CourseName when ' ' '+CourseName+ ' ' ' then ExamScore else 0 end)
[ '+CourseName+ '] '
from (select distinct CourseName from #temp_score) as a set @sql = @sql + 'into #临时表名'set @sql = @sql + 'from #temp_score group by StudentCode '
exec(@sql)
secect * into 表名 from 查询表名
--临时表方法
secect * into #表名 from 查询表名