转:SQL2008 UNPIVOT 列转行示例

时间：2014-02-21 21:03:47 收藏：0 阅读：494

CREATE TABLE pvt (VendorID int, Emp1 int, Emp2 int,
    Emp3 int, Emp4 int, Emp5 int);
GO
INSERT INTO pvt VALUES 
(1,4,3,5,4,4);
INSERT INTO pvt VALUES 
(2,4,1,5,5,5);
INSERT INTO pvt VALUES 
(3,4,3,5,4,4);
INSERT INTO pvt VALUES 
(4,4,2,5,5,4);
INSERT INTO pvt VALUES 
(5,5,1,5,5,5);
GO
 
select 
* from pvt
 
SELECT 
VendorID, Employee, Orders
FROM
   (SELECT 
VendorID, Emp1, Emp2, Emp3, Emp4, Emp5
   FROM 
pvt) p
UNPIVOT
   (Orders FOR 
Employee IN
      (Emp1, Emp2, Emp3, Emp4, Emp5)
)AS 
unpvt;
GO

原文：http://www.cnblogs.com/wucg/p/3559072.html