• 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