Re: this cannot be then best way

From: Ed Prochak <edprochak_at_gmail.com>
Date: 14 Jul 2006 14:09:42 -0700
Message-ID: <1152911382.467220.96810@m79g2000cwm.googlegroups.com>

akkha1234_at_gmail.com wrote:
> What if you have some holiday in between?
>

I'm thinking he handles that afterwards.

select count(*) from holidays where holiday_date between mydatestart and mydate ;

Yes there are boundary issues, but faster than looping for every day. (again this is all optimization for workdays X being relatively large most of the time this operation is called.

As always in performance tuning, the first key is: know your data.

Ed Received on Fri Jul 14 2006 - 16:09:42 CDT