Re: Calendar table workaround

2006-01-04 Thread Jonathan Mangin
RE: Calendar table workaround> >A table of dates to which to join other tables, >ensuring reports that reflect days for which no >data is available. I forget the query but I know it can be done. But can't you just have a table (called calendar?) with each entry having it'

Re: Calendar table workaround

2006-01-04 Thread Peter Brawley
queries.php#20. PB - Jonathan Mangin wrote: - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Jonathan Mangin" <[EMAIL PROTECTED]> Sent: Wednesday, January 04, 2006 1:25 PM Subject: Re: Calendar table workaround - Original

RE: Calendar table workaround

2006-01-04 Thread Jay Paulson \(CE CEN\)
> I have no idea what you are asking, which may explain why no one has replied > to your question yet. > > I've been working with relational databases for 20 years and I've never > heard the term "calendar table". What are you trying to accomplish? If you > describe clearly what you are trying to d

Re: Calendar table workaround

2006-01-04 Thread Jonathan Mangin
- Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Jonathan Mangin" <[EMAIL PROTECTED]> Sent: Wednesday, January 04, 2006 1:25 PM Subject: Re: Calendar table workaround > > - Original Message - > From: "Jonathan Mangin