This content has been marked as final. Show 4 replies
I don't think I understand the question , an example might help all
Example if have table
with following contents
example record 1.43, 01/05/2012,16/05/2012
If want to have another table which instead has 16 records one for each day
Thoughts on best way to do this.
Assuming you have a calendar table then you could join your rate table where the calendar table date is between the rate table start date and end date.
select a.rate, b.date from rate_table a, calendar_table b
where b.date between a.start_date and a.end_date
should translate easily into a two table join in OWB ?
Excellent - thanks yes have.