Re: SQL Inspiration needed

On 12-Jul-2011 09:30 , Jon Paris wrote:

I'm collecting alternative solutions for a couple of SQL "problems" -
things that would be relatively easy (if laborious) in native RPG.

So... Given that I have a table ORDERS which contains order and
shipping dates, I need to populate the shipping dates such that
the shipping date is 6 "business days" after the order date.

Business days can be determined from a calendar table keyed on date
and which contains a "Y" or "N" to indicate whether that date is a
business day or not.

Any ideas? The only ones we come up with are so darn nasty.

The calendar table should have a numeric data-type column which
represents the number of business days since\including the base-date in
that calendar. Then the shipping date being used has a specific number
of business days since the base date, and some specific [range of] date
has the[ir] number of business days six [or more] days later. This
makes maintenance of the calendar table more complicated, but a simple
one-pass programmed update performed after any maintenance could ensure
that column is set appropriately.

Regards, Chuck