Re: Avoiding an inline view using DML only
Date: Thu, 24 Apr 2008 06:01:04 -0700 (PDT)
> 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