Re: Avoiding an inline view using DML only

From: MoMorten <>
Date: Thu, 24 Apr 2008 06:01:04 -0700 (PDT)
Message-ID: <>

> 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

Original text of this message