Home Forums SQL Server 2008 T-SQL (SS2K8) Returning results for the previous year RE: Returning results for the previous year
tfifield
SSCrazy Eights
Points: 9655
More actions
January 12, 2012 at 12:13 pm
#1432830
When retrieving totals for the current year and prior year I almost always use a calendar table to do the heavy lifting. There is an example of this type of thing in this article:
http://www.sqlservercentral.com/articles/T-SQL/70482/
Todd Fifield