CREATE PROCEDURE GeneCmd
AS
declare @sql varchar(8000)
set @sql = 'select 姓名'
select @sql = @sql + ',sum(case 课程名称 when '''+课程名称+''' then 成绩 end) ['+课程名称+']'
from (select distinct 课程名称 from _tbTrainScore) as a
select @sql = @sql+' from _tbTrainScore group by 姓名'
select @sql
return
GO
AS
declare @sql varchar(8000)
set @sql = 'select 姓名'
select @sql = @sql + ',sum(case 课程名称 when '''+课程名称+''' then 成绩 end) ['+课程名称+']'
from (select distinct 课程名称 from _tbTrainScore) as a
select @sql = @sql+' from _tbTrainScore group by 姓名'
select @sql
return
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货