Shifting gears, is To.FinncPriod supposed to skip a couple of beats like this in your CASE statement???
WHEN T0.FinncPriod = '46' THEN '2013-Oct'
WHEN T0.FinncPriod = '45' THEN '2013-Sep'
WHEN T0.FinncPriod = '[font="Arial Black"]44[/font]' THEN '2013-Jun'
WHEN T0.FinncPriod = '[font="Arial Black"]41[/font]' THEN '2013-May'
WHEN T0.FinncPriod = '40' THEN '2013-Apr'
WHEN T0.FinncPriod = '39' THEN '2013-Mar'
--Jeff Moden
Change is inevitable... Change for the better is not.