DSXchange

Hi All,
Can you please let me know how to generate multiple recs from a single rec
ex:
i/p:
id,effdate
1,05/01/2011
2,11/01/2011

o/p:
id,effdate
1,05/01/2011
1,06/01/2011
1,07/01/2011
1,08/01/2011
1,09/01/2011
1,10/01/2011
1,11/01/2011
1,12/01/2011
1,13/01/2011
2,11/01/2011
2,12/01/2011
2,13/01/2011

ie I should get recs till currentdate()
thanks sai123

How many times are you going to post this question ?!!!!!

Hahah,this is very very imp req for me,I am struck on this,looking anyone has done in the past the same logic

Please don't post a question multiple times or in multiple forums. If anyone wants to continue to help with this, here is the original thread:

viewtopic.php?p=387009

This one is done.