Note that it is CRITICALLY IMPORTANT that you do NOT wrap a function around a column in the WHERE clause!!! Do filtering like Ed shows, not by using things like YEAR(), MONTH(), etc.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service