SARGABLE way of getting orders from exactly 10 days ago

• Khades

  SSCrazy

  Points: 2067

  More actions

  July 19, 2011 at 3:01 pm

  #241675

  Could someone help me out with this logic.

  I have an order table with an Order_Date column. I need all the orders from 10 days ago(for example All the orders that were placed on the 9th if the query runs today)

  What's the best Sargable way to do this?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 19, 2011 at 3:03 pm

  #1355176

  select (columns needed)

  from Table

  where DateColumn >= cast(dateadd(day, -10, getdate()) as Date)

  and DateColumn < cast(dateadd(day, -9, getdate()) as Date);

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• Khades

  SSCrazy

  Points: 2067

  More actions

  July 19, 2011 at 4:12 pm

  #1355210

  Thanks again GS!!