Thanks.

Here is the final SQL i have:

I created a ReportDates table with the month, year

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [ReportDates](

[DateMonth] [int] NULL,

[DateMonthName] [nchar](10) NULL,

[DateYear] [int] NULL,

[ThisDate]...

Hi,

Thanks for response, here is what i have so far:

If I set the monthly span to -10 (last 10 months), i only get records for last 8 months. No zero...