| :: Getting Records for a Fiscal Year :: show all messages | Post a New Message | Post a Reply |
 Re: Getting Records for a Fiscal Year | Post a Reply |
from: Washington, DC
CASE WHEN ([Reporting Month] < 10) THEN [Reporting Year]-1
ELSE [Reporting Year]
END
INTO #T1
FROM Visitation
WHERE [Reporting Year] IN (1999-1,1999,2000,2001,2002,2002+1)
SELECT SUM(Visitation) AS [Total Visits], FiscalYear FROM #T1
WHERE FiscalYear IN (1999,2000,2001,2002)
GROUP BY FiscalYear
ORDER BY FiscalYear
DROP TABLE #T1
-------------------------
Ghost