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