Re: Avoiding an inline view using DML only

> create table almanac
> (adate date,
> other columns not relevant to this issue);
>
> Now, a suitable join between almanac and events, with a restriction to
> almanac dates between the low end and high end dates supplied by the user,
> can solve the problem. If necessary, I can work out the suitable join.
> Maybe the OP can work it out.
>
> This technique is widely used in data warehouses to avoid putting messy
> calendar computations in hundreds of queries.

Thanks for the tips guys, works beautifully!

Morten Received on Thu Apr 24 2008 - 15:01:04 CEST