Multi Column PIVOT 입니다.

 

IF OBJECT_ID('TBLX') IS NOT NULL

DROP TABLE TBLX

GO

 

CREATE TABLE TBLX

(CODE INT

,CODE2 INT

,COL_ORDER INT

,COL2 VARCHAR(100)

,COL3 VARCHAR(100)

)

GO

 

 

INSERT INTO TBLX VALUES (1,1,1,'A','1')

INSERT INTO TBLX VALUES (1,1,2,'B','2')

INSERT INTO TBLX VALUES (1,1,3,'C','3')

INSERT INTO TBLX VALUES (2,2,1,'D','4')

INSERT INTO TBLX VALUES (2,2,2,'E','5')

INSERT INTO TBLX VALUES (2,2,3,'F','6')

GO

 

 

SELECT CODE, CODE2

     , MAX([1]) COL21, MAX([2]) COL22, MAX([3]) COL23

     , MAX([1000]) COL31, MAX([2000]) COL32, MAX([3000]) COL33

  FROM (SELECT CODE

             , CODE2

             , COL_ORDER

             , COL_ORDER * 1000 COL_ORDER2

             , COL2

             , COL3

          FROM TBLX) T

 PIVOT (MAX(COL2) FOR COL_ORDER  IN ([1], [2], [3])) AS P

 PIVOT (MAX(COL3) FOR COL_ORDER2 IN ([1000], [2000], [3000])) AS P2

 GROUP BY CODE, CODE2

 

이 게시물을...
profile

select top 1 email from world where hobby = 'sql' and sqlguru = 1 order by sqllevel desc;

go
minsouk@hotmail.com 

김민석 / SQL 프런티어 1기 / http://www.sqler.com / http://cafe.naver.com/sqlmvp