您应该可以使用类似于以下内容的东西：
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_Totalfrom( select peakrange, daysofreq, total, sum(total) over(partition by PeakRange) peak_Total from requirementRange) dpivot( sum(total) for daysofreq in ([Day 0], [Day 1], [Day 2], [>2 Days])) pivorder by peakrange;
参见带有演示的SQL Fiddle
