|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21 |
CREATE TABLE pvt (VendorID int, Emp1 int, Emp2 int, Emp3 int, Emp4 int, Emp5 int);GOINSERT 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);GOselect
* from pvtSELECT
VendorID, Employee, OrdersFROM (SELECT
VendorID, Emp1, Emp2, Emp3, Emp4, Emp5 FROM
pvt) pUNPIVOT (Orders FOR
Employee IN (Emp1, Emp2, Emp3, Emp4, Emp5))AS
unpvt;GO |
原文：http://www.cnblogs.com/wucg/p/3559072.html