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 29, 2013 at 12:04 pm

    #1636728

    I'm thinking something along the lines of

    SELECT TOP 6 cols

    FROM tables

    WHERE DATENAME(weekday, dateCol) = DATENAME(weekday, GETDATE());