Home Forums SQL Server 2005 T-SQL (SS2K5) dateAdd inside where clause RE: dateAdd inside where clause

  • November 25, 2008 at 2:24 am

    #902974

    SELECTs.StoreName,

    s.StoreID,

    h.StoreDate,

    h.OpenTime,

    h.ClosingTime,

    h.Comments

    fromschema.mytable2 as s

    left JOINschema.mytable1 as h on h.[StoreID] = s.[StoreID]

    AND h.[StoreDate] between GetDate() and DateAdd(dd, 7, h.StoreDate)

    WHEREs.StoreName = 'store'

    N 56°04'39.16"
    E 12°55'05.25"