rVadim (9/22/2012)
You can also UNIONize quarters and then select from that union using quarter number as filter in a WHERE clause.
SELECT *
FROM (
SELECT Account, QTR1 AS QuarterValue, 1 AS QuarterNumber FROM ....
UNION ALL
SELECT Account, QTR2 AS QuarterValue, 2 AS QuarterNumber FROM ....
UNION ALL
....
)
WHERE QuarterNumber = 2
You can also create procedure passing quater number and then doing IF ... ELSE
How will any of that produce the desired output?
--Jeff Moden
Change is inevitable... Change for the better is not.