Check the stats on the table.
Look at execution plan for bootlenecks/scans etc
Veryify order of Where parameters works to effectively
Check the indexes for existence and fragmentation.
Definitely pre calc the date comparision.
If stored procedure then after verifying stats are up to date then I'd do an sp_recompile on the sProc
Much to learn, teach me Yoda
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/