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'
SQL pivot函数横向统计
该SQL查询从vw_TmpDailyIdleHours_Summary_WithoutQuality视图中提取数据,按PlanDate和MainLoom进行分组,并使用PIVOT函数将IHDesc的不同类别转换为列,展示各类别的总分钟数。查询结果包括特定日期范围(2023年2月15日)内的各项活动详情。
摘要由CSDN通过智能技术生成