Try building a calendar table, joining on your dates. Then you can aggregate by month using the month values in the calendar table. See the following article[/url] for details about how to use calendar tables.