MS SQL.Select-Pivot. UnPivot

[ MS SQL.Select-Pivot ]

. 참고 url -  (http://blog.naver.com/waws01/60201927284)

1. Pivot

SELECT * FROM ( SELECT ID,ORDERS FROM COUNT_TSET2 WITH(NOLOCK) )AS P PIVOT (COUNT(ORDERS) FOR ORDERS IN([1],[2],[3],[4],[5],[6],[7],[8]) )AS PivotTest

2. UnPivot

SELECT ID,ORDERS FROM ( SELECT ID,A,B,C,D,E,F FROM COUNT_TEST WITH(NOLOCK) )P UNPIVOT (ORDERS FOR COUNTS IN (A,B,C,D,E,F) )AS UNP GO