如果您可以将第一个查询中的数据加载到中间临时表中,则可以执行此操作:
DECLARE @t TABLE
(
ProductClass INT
, InspectDays INT
, ProcessDays INT
, ShipDays INT
)
INSERT INTO @t
SELECT 1
, 2
, 4
, 8
UNION ALL
SELECT 1
, 4
, 5
, 2
UNION ALL
SELECT 5
, 2
, 4
, 8
UNION ALL
SELECT 10
, 3
, 5
, 2
SELECT 'Avg Inspect'
, [01] = AVG(CASE WHEN ProductClass = 1 THEN InspectDays
END)
, [05] = AVG(CASE WHEN ProductClass = 5 THEN InspectDays
END)
, [10] = AVG(CASE WHEN ProductClass = 10 THEN InspectDays
END)
FROM @t
UNION ALL
SELECT 'Avg Process'
, [01] = AVG(CASE WHEN ProductClass = 1 THEN ProcessDays
END)
, [05] = AVG(CASE WHEN ProductClass = 5 THEN ProcessDays
END)
, [10] = AVG(CASE WHEN ProductClass = 10 THEN ProcessDays
END)
FROM @t