Sql Server 两个透视的合并处理核心代码

核心代码:

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