세로 데이터 가로로 회전하여 출력하기!

select 
      WorkGrName
    , substring(YearMonth ,1,4) Years
    , SUM(CASE WHEN right(YearMonth,2) ='01' THEN ISNULL(SumAmt,0) else 0 end) 'Amt01'
    , SUM(CASE WHEN right(YearMonth,2) ='01' THEN ISNULL(SumQty,0) else 0 end) 'Qty01'
    , SUM(CASE WHEN right(YearMonth,2) ='02' THEN ISNULL(SumAmt,0) else 0 end) 'Amt02'
    , SUM(CASE WHEN right(YearMonth,2) ='02' THEN ISNULL(SumQty,0) else 0 end) 'Qty02'
    , SUM(CASE WHEN right(YearMonth,2) ='03' THEN ISNULL(SumAmt,0) else 0 end) 'Amt03'
    , SUM(CASE WHEN right(YearMonth,2) ='03' THEN ISNULL(SumQty,0) else 0 end) 'Qty03'
    , SUM(CASE WHEN right(YearMonth,2) ='04' THEN ISNULL(SumAmt,0) else 0 end) 'Amt04'
    , SUM(CASE WHEN right(YearMonth,2) ='04' THEN ISNULL(SumQty,0) else 0 end) 'Qty04'
    , SUM(CASE WHEN right(YearMonth,2) ='05' THEN ISNULL(SumAmt,0) else 0 end) 'Amt05'
    , SUM(CASE WHEN right(YearMonth,2) ='05' THEN ISNULL(SumQty,0) else 0 end) 'Qty05'
    , SUM(CASE WHEN right(YearMonth,2) ='06' THEN ISNULL(SumAmt,0) else 0 end) 'Amt06'
    , SUM(CASE WHEN right(YearMonth,2) ='06' THEN ISNULL(SumQty,0) else 0 end) 'Qty06'
    , SUM(CASE WHEN right(YearMonth,2) ='07' THEN ISNULL(SumAmt,0) else 0 end) 'Amt07'
    , SUM(CASE WHEN right(YearMonth,2) ='07' THEN ISNULL(SumQty,0) else 0 end) 'Qty07'
    , SUM(CASE WHEN right(YearMonth,2) ='08' THEN ISNULL(SumAmt,0) else 0 end) 'Amt08'
    , SUM(CASE WHEN right(YearMonth,2) ='08' THEN ISNULL(SumQty,0) else 0 end) 'Qty08'
    , SUM(CASE WHEN right(YearMonth,2) ='09' THEN ISNULL(SumAmt,0) else 0 end) 'Amt09'
    , SUM(CASE WHEN right(YearMonth,2) ='09' THEN ISNULL(SumQty,0) else 0 end) 'Qty09'
    , SUM(CASE WHEN right(YearMonth,2) ='10' THEN ISNULL(SumAmt,0) else 0 end) 'Amt10'
    , SUM(CASE WHEN right(YearMonth,2) ='10' THEN ISNULL(SumQty,0) else 0 end) 'Qty10'
    , SUM(CASE WHEN right(YearMonth,2) ='11' THEN ISNULL(SumAmt,0) else 0 end) 'Amt11'
    , SUM(CASE WHEN right(YearMonth,2) ='11' THEN ISNULL(SumQty,0) else 0 end) 'Qty11'
    , SUM(CASE WHEN right(YearMonth,2) ='12' THEN ISNULL(SumAmt,0) else 0 end) 'Amt12'
    , SUM(CASE WHEN right(YearMonth,2) ='12' THEN ISNULL(SumQty,0) else 0 end) 'Qty12'
    
    FROM temp2
    
    GROUP BY substring(YearMonth ,1,4) , WorkGrName , WorkGrCode
    
    order by WorkGrCode

GROUP BY 절과 SUM 함수를 이용하여 웝별 데이터를 가로로 출력해 보여주는 방법! 

주로 통계 쪽에서 많이 사용할 것 같다.