I have process that uses date ranges in a row for each project, say Start Date of 2/15/2013 and End Date of 6/18/2013. What I need to do is take this date range and separate it into its various months, that is, the destination table would have a column for each month. The Data would be transformed from one column in the source to multiple column in the destination, that is, the destination columns and data should be like:
Source Row:
ProjectID UserID StartDate EndDate
Prj_1 someone 2/15/2013 6/18/2013
Would be transformed into the below table configuration:
ProjectI USerID StartDate EndDate
PRJ_1 someone 2/15/2013 2/28/2013
PRJ_1 someone 3/1/2013 3/31/2013
PrJ_1 someone 4/1/2013 4/30/213
Prj_1 someone 5/1/2013 5/31/2013
Prj_1 someone 6/2/2013 6/18/2013
Just not sure how to go about this
Sandra
thank you, Sandra