I need to get a minimum month and year from a table and then a row for every month/year up to today.
How to I achieve that, here's the query I'm using below:
MIN(DATENAME(MONTH, dtePostedToWebsiteDate)) as MinMonth
,MIN(Year(dtePostedToWebsiteDate)) as MinYear
,'' as [RowForEachMonth] --??
Where bitPostToWebSite = 1