核心代码:
create proc p_tempT as SELECT Name,[Math] as 'MathRank',[Chinese] 'ChineseRank',[SqlServer] 'SqlServerRank' into #r1 FROM (select Name,CouName,MidRank from Stu) AS P PIVOT(sum(MidRank) FOR CouName IN([Math],[Chinese],[SqlServer])) AS T; SELECT Name,[Math] ,[Chinese] ,[SqlServer] into #r2 FROM (select Name,CouName,MidScore from Stu) AS P PIVOT(sum(MidScore) FOR CouName IN([Math],[Chinese],[SqlServer])) AS T; select #r1.Name,Math,MathRank,Chinese,ChineseRank from #r1,#r2 where #r1.Name=#r2.Name; go