New Table Btwn 2 Fields

[#1]

Hey Guys,

I have a table with id, date1 and date2.

I want to be able to create a new table with records inbtwn the dates.

So record

1, 1/1/2010, 1/3/2010

Would result in

1, 1/1/2010
1. 1/2/2010
1, 1/3/2010

Any ideas on how I can do it?

[#2]

Sorry, just found the answer

Date:
LOAD
date1,
date2,
id,
date(date1 + iterno()-1) as DateLink
RESIDENT table1
WHILE date1 + iterno()-1 <= date2;