20041118190116490.txt

管理学院教务平台:教师与学生,教师与教师交流平台.新闻发布,作业上传. ASP.NET.SQL SERVER 2

declare @sql varchar(8000)
set @sql = 'select tblStudent.Name,'
select @sql = @sql + 'sum(case tblSchoolWork.Name when '''+SchoolWorkName+''' 
                          then  tblStudentGrade.Grade  else 0 end) as '''+SchoolWorkName+''','
 from (select  tblSchoolWork.Name as SchoolWorkName from tblSchoolWork where tblSchoolWork.SchoolWorkIDKey in(78)) as a
select @sql = left(@sql,len(@sql)-1)  
 select @Sql                          then  tblStudentGrade.Grade  else 0 end) as '5'