SQL pivot函数横向统计

JohnTse VIP

于 2023-06-23 14:36:56 发布

阅读量132

点赞数

文章标签： sql 数据库开发语言前端 sqlserver

本文链接：https://blog.csdn.net/jjx168/article/details/131350479

版权

       select PlanDate,
               MainLoom,
               [Running],
               [Alteration],
               [Bad Beam],
               [Beam Gaiting],
               [Beam Unbalance],
               [Color Reject],
               [Idle],[Incomplete Spec],[Insufficient Quantity on beam],
               [Instructions],
               [Maintenance],
               [Mini Bulk],[No Plan],
               [Order Complete],
               [Planning Add-ON],[PURCHESING],
               [Quality Improvement],
               [Stock Controll],
               [Technical Fault],
               [W F Alteration],
               [W F Beam - Alteration],
               [W F Beam - Production],
               [W F Warp Yarn],
               [Waiting for color approval],
               [Warp Break],
               [Weft Break],
               [Incorrect beam order request]
               from (
                   select PlanDate, MainLoom, IHDesc, sum([Minutes]) as [Minutes] from [dbo].[vw_TmpDailyIdleHours_Summary_WithoutQuality] group by PlanDate, MainLoom, IHDesc) cc
               pivot (
               sum([Minutes])
               for IHDesc in (
               [Running],
               [Alteration],
               [Bad Beam],
               [Beam Gaiting],
               [Beam Unbalance],
               [Color Reject],
               [Idle],[Incomplete Spec],[Insufficient Quantity on beam],
               [Instructions],
               [Maintenance],
               [Mini Bulk],[No Plan],
               [Order Complete],
               [Planning Add-ON],[PURCHESING],
               [Quality Improvement],
               [Stock Controll],
               [Technical Fault],
               [W F Alteration],
               [W F Beam - Alteration],
               [W F Beam - Production],
               [W F Warp Yarn],
               [Waiting for color approval],
               [Warp Break],
               [Weft Break],
               [Incorrect beam order request])
               ) as x
               where PlanDate >= '02/15/2023' and PlanDate< = '02/15/2023'