Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Jackson The Cost of Function Use In A Where Clause RE: The Cost of Function Use In A Where Clause

  • February 28, 2008 at 3:40 am

    #783074

    Thanks for this good Article

    If you wont use time data for searching you need to cut off the time information.

    The query can look like:

    [font="Courier New"]WHERE PlacedOnQueue <= DateAdd(mm,-30,DateAdd(dd,DateDiff(dd,0,GetDate()),0)) [/font]