| :: 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: Laurel, MD
SELECT *, 'FiscalYear' =
CASE
WHEN ([Reporting Month] < 10) THEN [Reporting Year]-1
ELSE [Reporting Year]
END
INTO #T1
FROM Visitation
SELECT * FROM #T1
WHERE FiscalYear IN (1999,2000,2001,2002)
ORDER BY FiscalYear
DROP TABLE #T1
-------------------------
Master of the Game