Home Forums SQL Server 2008 T-SQL (SS2K8) Find the last 6 Tuesdays or Wed or Whatever day. RE: Find the last 6 Tuesdays or Wed or Whatever day.

  • July 31, 2013 at 2:19 pm

    #1637560

    SELECTDATEADD(DAY, Number, '17530101')

    FROM(

    VALUES(DATEDIFF(DAY, '17530108', GETDATE())),

    (DATEDIFF(DAY, '17530115', GETDATE())),

    (DATEDIFF(DAY, '17530122', GETDATE())),

    (DATEDIFF(DAY, '17530129', GETDATE())),

    (DATEDIFF(DAY, '17530205', GETDATE())),

    (DATEDIFF(DAY, '17530212', GETDATE()))

    ) AS d(Number)

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