How do I dynamically generate rows?
Posted: Tue Mar 21, 2006 10:21 am
Hi,
I want to build a job that generates rows for each row that coming from the source.
The problem is that the number of rows is specific for each row and determined by calculation.
Example:
The first row in the source is producing only one row and the second row produce 3 rows because there are 3 days between these dates.
Appreciate the help,
Gil
I want to build a job that generates rows for each row that coming from the source.
The problem is that the number of rows is specific for each row and determined by calculation.
Example:
- Source:
Start_date, End_date, dummy
12/10/2005, 12/10/2005, aaa
12/10/2005, 14/10/2005, bbb
Target:
12/10/2005, 12/10/2005, aaa
12/10/2005, 14/10/2005, bbb
13/10/2005, 14/10/2005, bbb
14/10/2005, 14/10/2005, bbb
The first row in the source is producing only one row and the second row produce 3 rows because there are 3 days between these dates.
Appreciate the help,
Gil