This is a SQL trick for spreading out data across months on a single row. It also works with Sybase TSQL. The 1-ABS(SIGN()) function will evaluate to zero for all months outside of column.

 SELECT	 A,B,C,FISCAL_YEAR,may = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month - 1)))),jun = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month - 2)))),jul = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month - 3)))),aug = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month - 4)))),sep = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month - 5)))),oct = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month - 6)))),nov = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month - 7)))),dec = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month - 8)))),jan = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month - 9)))),feb = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month -10)))),mar = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month -11)))),apr = SUM(T1.number_of_cases * (1 - ABS(SIGN(T1.fiscal_month -12))))FROM	 table_name T1GROUP BY A,B,C,FISCAL_YEAR