Luis Cazares (2/4/2014)

---

Why wouldn't you want to use a nice [font="Arial Black"]pre-aggregated [/font]cross tab approach?

SELECT

SUM(CASE qtr WHEN 1 THEN sales END) AS q1,

SUM(CASE qtr WHEN 2 THEN sales END) AS q2,

SUM(CASE qtr WHEN 3 THEN sales END) AS q3,

SUM(CASE qtr WHEN 4 THEN sales END) AS q4

FROM (SELECT qtr, SUM(sales) sales

FROM #p

GROUP BY qtr)p;