Home Forums SQL Server 2008 T-SQL (SS2K8) help me to create useful index (while using dynamic query) RE: help me to create useful index (while using dynamic query)

  • February 23, 2013 at 9:00 pm

    #1590631

    For the date comparison, I am using

    CreatedDate > DATEADD(dd, -90, GETUTCDATE())

    Should I change the ">" to "between"?

    Currently, I am using below query:

    WHERE CategoryID = 1 AND CountryCode = 'GB' AND CreatedDate > DATEADD(dd, -90, GETUTCDATE())

    AND StateID = 1737 AND CityID = 86