Re: Help with sql-query

In article <kpnm73dh8u2far2mjmq1rcdl2nqv7cnhtc_at_4ax.com>, sybrandb_at_hccnet.nl says...
> On Thu, 21 Jun 2007 15:02:29 -0000, Matt T <puskas.duck_at_gmail.com>
> wrote:
>
> >Ugly code alert - and wouldn't want to debug that.
> >
> >Surely the elegant (well designed!) solution is a calendar_dates
> >table.....
>
> If you want to clutter your database with redundant rubbish, by all
> means do, but your so-called 'solution' isn't elegant at all, Charles'
> solution s. Your solution is NOT well designed! and just a *kludge*

Interestingly, this design is recommanded in some datawarehouse books, where *not* using it is considered a kludge :-)

Context is everything, I guess

• Raoul