• Something like this?

    DECLARE@min-2 DATETIME

    DECLARE@max-2 DATETIME

    SELECT@min-2 = MIN(dtePostedToWebsiteDate)

    FROMdtlVacancyPostAudit

    WHEREbitPostToWebSite = 1

    SET@max-2 = DATEADD(MONTH,DATEDIFF(MONTH,0,CURRENT_TIMESTAMP)+1,0)

    SELECTDATENAME(MONTH,@min) AS MinMonth,

    YEAR(@min) AS MinYear,

    DATEADD(MONTH,sv.number,@min)

    FROMmaster.dbo.spt_values AS sv -- You can use a Tally table instead as well

    WHEREsv.type = 'P'

    ANDDATEADD(MONTH,sv.number,@min) < @max-2

    You can check the below link for a Tally table creation script

    http://www.sqlservercentral.com/scripts/Advanced+SQL/62486/


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/