Home Forums SQL Server 2005 T-SQL (SS2K5) Correlated sub query takes more time to return result RE: Correlated sub query takes more time to return result

  • Are you converting the dates because you want to match on the date, but the time is immaterial? If so, check out this thread for some ideas on changing the date compare to look at a range:

    http://www.sqlservercentral.com/Forums/Topic529603-8-1.aspx#bm529668


    And then again, I might be wrong ...
    David Webb