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

  • 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)