OH! SPID!  I thought you meant "spud" and built a spud cannon over the weekend   Hmmm... maybe THAT will work on the users...

Joe... I don't use formulas for the Holidays nor did I suggest that... that would be stupid.  Go back and look at what I said... I agree that a Holiday...

Manish,

I appreciate your attempt at simplification of the problem ... but you at least need to say that your real code has 10-12...

Now, THAT sounds like a cross-join... post the code and let's have a look-see... (provided it's not hundreds of lines long ).

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...