Re: Vs: Function to calculate weekdays left in a month
From: Tony Adolph <tony.adolph.dba_at_gmail.com>
Date: Tue, 5 Aug 2008 12:15:54 +1200
Message-ID: <4a38d9060808041715v13a82888w1e8ed0f1fcf8523e@mail.gmail.com>
Date: Tue, 5 Aug 2008 12:15:54 +1200
Message-ID: <4a38d9060808041715v13a82888w1e8ed0f1fcf8523e@mail.gmail.com>
It would be too easy :-)
Is there book out there along the lines of 1000 SQL problems.. I've got something similar in perl (algorithms in perl I think its called).
Maybe the uni students on this list have something?
Tony
On Tue, Aug 5, 2008 at 10:12 AM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:
> Hey now, scope creep!! It wasn't in the original request!! :-)
>
> Seriously, though, I thought about that when I was writing my query....but
> he didn't mention holidays, so I didn't consider a solution that accounted
> for them....
>
> I suppose you could do something with a lookup table of valid holidays, and
> hook it into what I've done without too much work....I think....
>
> -Mark
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 04 2008 - 19:15:54 CDT