create proc pro_new1
@year char(10)='2012'
as
select 学号 , 成绩 as 数学期中成绩 into #a from table where
课程号='1002' and 年度= @year
select t1.学号 , t1. 成绩 as 计算机期中成绩 , isnull(t2.数学期中成绩,0) from table t1
left outer join #a t2 on t1.学号=t2.学号
and t1.年度= @year
and t1.课程号='2005'
温馨提示:内容为网友见解,仅供参考