i have the Final Output Table with the fields Workstart Date and WorkEnd date.
lets us say the work start date is 01-01-2009 and
workend date is 31-12-2009.
so, in my final output table i want to generate 12 dynamic columns, each column referring to each month.
like 01-01-2009 is the first column
01-02-2009 is the second column
01--3-2009 is the third column etc.
the work start date and workend date is are also varying depending upon requirement.
if work start date is 01-01-2009 and
workend date is 31-12-2010. then in this case i have to generate 24 dynamic columns.
How to do this.