Home Forums SQL Server 2008 SQL Server Newbies How to set index for these select queries RE: How to set index for these select queries
prakash.kumar3669
Valued Member
Points: 53
More actions
January 18, 2013 at 4:06 am
#1578624
WHERE SomeNumber >=0 AND SomeNumber < 0
this is the actual condition: SubmitDate>=DATEADD(day,DATEDIFF(day,0,GETDATE()),@duration) AND SubmitDate < DATEADD(day,DATEDIFF(day,0,GETDATE()),1)