• Using the DATEPART function will not allow the optimizer to use the index on the reortsentdate column so your statement will force a table scan.

    For more info on how to work with sql server dates you might want to look at these articles:

    http://www.sql-server-performance.com/fk_datetime.asp

    http://www.karaszi.com/SQLServer/info_datetime.asp