|
On 12-Jul-2011 09:30 , Jon Paris wrote:
I'm collecting alternative solutions for a couple of SQL "problems" -The calendar table should have a numeric data-type column which
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.
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-2026 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.
midrange.com
