您应该可以使用类似于以下内容的东西:
select
peakrange,
coalesce([Day 0], 0) [Day 0],
coalesce([Day 1], 0) [Day 1],
coalesce([Day 2], 0) [Day 2],
coalesce([>2 Days], 0) [>2 Days],
peak_Total
from
(
select peakrange, daysofreq, total,
sum(total) over(partition by PeakRange) peak_Total
from requirementRange
) d
pivot
(
sum(total)
for daysofreq in ([Day 0], [Day 1], [Day 2],
[>2 Days])
) piv
order by peakrange;