| :: 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
DECLARE @FiscalYear INT
SELECT @FiscalYear = 2002
SELECT * FROM Visitation
WHERE ([Reporting Year] = @FiscalYear AND [Reporting Month] > 9)
OR ([Reporting Month] < 10 AND [Reporting Year] = (@FiscalYear + 1))
ORDER BY [Reporting Year],[Reporting Month]
-------------------------
Master of the Game