select
distinct
Sub_name
as
Sub_name,a.Sub_Code
into #temptin
from t_ExamSubject a,t_SubjectManage b
where a.Exa_Code = ' 2 '
and a.Sub_Code = b.Sub_Code
order by a.Sub_Code;
select a. * ,stu_Name,sub_Name
into #tempMain
from t_resultManage a,t_StudentManage b,t_subjectManage c
where a.Stu_Code = b.Stu_Code and a.Sub_code = c.Sub_code
declare @sql varchar ( 8000 )
set @sql = ' select stu_Name as 学生姓名 ' ;
select @sql = @sql + ' ,max(case sub_Name
when ''' + sub_Name + ''' then sub_numeric end) [ ' + sub_Name + ' ] '
from #temptin; set @sql = @sql + ' from #tempMain group by stu_code,stu_name order by stu_code ' ;
exec ( @sql )
drop table #temptin
drop table #tempmain
横转竖
into #temptin
from t_ExamSubject a,t_SubjectManage b
where a.Exa_Code = ' 2 '
and a.Sub_Code = b.Sub_Code
order by a.Sub_Code;
select a. * ,stu_Name,sub_Name
into #tempMain
from t_resultManage a,t_StudentManage b,t_subjectManage c
where a.Stu_Code = b.Stu_Code and a.Sub_code = c.Sub_code
declare @sql varchar ( 8000 )
set @sql = ' select stu_Name as 学生姓名 ' ;
select @sql = @sql + ' ,max(case sub_Name
when ''' + sub_Name + ''' then sub_numeric end) [ ' + sub_Name + ' ] '
from #temptin; set @sql = @sql + ' from #tempMain group by stu_code,stu_name order by stu_code ' ;
exec ( @sql )
drop table #temptin
drop table #tempmain
横转竖