SQL PIVOT 行转列

SQL PIVOT 行转列例子

SELECT

     t2.组序号 as 组序号, t2.工资表编号 as 工资表编号, t2.子组号 as 子组号, t2.产品编号 as 产品编号, t2.子行号 as 子行号, t2.行颜色 as 行颜色, t2.统计 as 统计, t2.汇总标记 as 汇总标记, t2.显示顺序 as 显示顺序, t2.分组汇总行标记 as 分组汇总行标记, '计数' as  [项目],[0] as [合计],[1] as [_1],[2] as [_2],[3] as [_3],[4] as [_4],[5] as [_5]

from [##pivot_1370_5RT0YHO1V_0000000003] t1
 PIVOT  (
              MAX( t1.计数) for t1.转置项目号 in ( [0],[1],[2],[3],[4],[5] )
         ) as t2
 ) as a


 order by 工资表编号,产品编号