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/
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/