RE: How To Get a row(date) for each month

SSCrazy

Points: 2218

June 13, 2013 at 7:12 am

I need something like this but now its not grouping the months properly:

Select

MIN(DATENAME(MONTH, dtePostedToWebsiteDate))as MinMonth

,MIN(Year(dtePostedToWebsiteDate))as MinYear

From dtlVacancyPostAudit

Where bitPostToWebSite = 1

Group By dtePostedToWebsiteDate

Having dtePostedToWebsiteDate between MIN(dtePostedToWebsiteDate) And GETDATE()

This is the output I'm getting:

MinMonthMinYear

June2012

July2012

September2012

November2012

January2013

February2013

March2013

April2013

May2013

June2013