I trying to write a forecast report, but the problem is in the table the data comes from, not all of the records will have a full six months worth of data for the forecast. So I need to be able to create fake dates/0 amounts for up to six months in the future from the following sql
Declare @QuoteDate datetime
Set @QuoteDate = '09/01/2012'
QuoteType = 'C'
When the query runs, it may not have 6 months worth of reqdate/Quoteunits for each material.
I need to be able to return a month/year for the reqdate and 0 for the Quoteunits for six months in the future.
I've created a dates table with all the dates from 1/1/1900 to 12/31/2099 so i can pull the dates from that to create the fake dates. but i'm not sure how best to do that. i tried I cross join to not avail.
what do i need to do for this?