Transforming a from/to date structure to daily records

[system]

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…

Hope this helps

---

prabaharan (BOB member since 2007-05-16)