|
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 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 |