Re: SQL Inspiration needed -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.