Re: SQL Inspiration needed

On Tue, Jul 12, 2011 at 12:30 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

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

This particular one doesn't even seem all that laborious in 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.

I'm not familiar with recursive SQL, but I like Luis's idea of a UDF,
as it would be easy to implement, easy to use, flexible, and reusable.

Barring that, the most "SQLish" solution that comes to my mind is to
(brace yourself) make a new table that is keyed on input date and has
a column for "6 business days after".

John Y.