I would feel some kind of anxiety about the system which needs 9 gig for operational data.

You ain't...

I'm thinking that your problem is a combination of using the wrong Provider, using a client side cursor, and doing a count in the app instead of on the server.

Only if you use dynamic SQL...

Don't need a "date walking loop".  Just use the formula I posted to calculate the week days and hit a holiday table for the number of days to subtract

Totally wrong approach?   Heh, extraordinary claims require extraordinary proof, Joe.  If you're talking about the code I submitted and if you think a calendar...

Wasn't meant to resolve business days per month nor figure out what a business month consists of... it was meant to find weekdays (despite the title).  If you don't need...

Actually, that's quite a nice compliment...  thanks 

Dizzy...

I see no similar problem... it operates as expected for the dates you posted having problems with...

-- Wed 1st May 2002 and an end date of Fri 31st...

Heh... sorry... you post faster than I do

No... not the right way... you have to copy a quote box from some other thread and paste it into your response... then edit what's in that graphic by copying...

Yes... sp__ will still go to MASTER first because it still contains sp_ as the first 3 characters.

Yes, you can do this without a function... it'll be a bit (maybe...

Ah... Matt's right... I left out a step... I should have said to insert all your missing rows into YourTable first, then run my code... don't need to add extra...

You know... that's a much better answer...

Roger that... still shouldn't matter but "can do"...

This obviously won't work if foreign keys exist...

First things first... make a "backup" of the table...