SQLServer-同一列上有多个PIVOT

要进行透视，

multiple column

Muliple Pivot's

multiple Aggregates

SELECt ID,       NAME,       Max([Raised to Supplier(PLANED)])[Raised to Supplier(PLANED)],       Max([base Test Date(PLANED)])[base Test Date(PLANED)],       Max([Washing Approval(PLANED)])[Washing Approval(PLANED)],       Max([Raised to Supplier(ACTUAL)])[Raised to Supplier(ACTUAL)],       Max([base Test Date(ACTUAL)])[base Test Date(ACTUAL)],       Max([Washing Approval(ACTUAL)])[Washing Approval(ACTUAL)]FROM   (SELECT 1 ID,'45rpm' NAME,'Raised to Supplier' + '(PLANED)' MSNAME_pl,'Raised to Supplier' + '(ACTUAL)' MSNAME_ac,'2014-12-17' PLANED,'2015-12-17' ACTUAL        UNIOn ALL        SELECT 1,'45rpm','base Test Date' + '(PLANED)','base Test Date' + '(ACTUAL)','2014-12-18','2015-12-18'        UNIOn ALL        SELECT 1,'45rpm','Washing Approval' + '(PLANED)','Washing Approval' + '(ACTUAL)','2014-12-19','2015-12-19') a       PIVOT ( Max(PLANED)  FOR MSNAME_pl IN ([Raised to Supplier(PLANED)],         [base Test Date(PLANED)],         [Washing Approval(PLANED)]) ) AS p1        PIVOT ( MAX(ACTUAL)    FOR MSNAME_ac IN ([Raised to Supplier(ACTUAL)],          [base Test Date(ACTUAL)],          [Washing Approval(ACTUAL)])) p2GROUP BY ID, NAME