Insert missing rows based on Start and End Number

[system]

Check this out

120×120 10.4 KB

Hi, I am trying convert one row in to many row below is the record in coming clientid locationid planid flightid stardate enddate 123 345 567 897 4/19/2004 4/25/2004 I need to convert this like below: clientid locationid planid flightid date 123 345 567 897 4/19/2004 0:00 123 345 567 897 4/20/2004 0:00 123 345 567 897 4/21/2004 0:00 123 345 567 897 4/22/2004 0:00 123 345 567 897 4/23/2004 0:00 123 345 567 897 4/24/2004 0:00 123 345 567 897 4/25/2004 0:00 I don’t thin…

Insetad of date generation transformation you can use row generation.

Hope this helps.

---

prabaharan (BOB member since 2007-05-16)