Outstanding... thanks Grant!

Finally... someone else who believes in readability of code!

Heh... you and I are on the same page... that's the "magic" I was referring to... sorry I misread your previous post on the subject.

Yep, made the correction on the...

Haven't done any million row testing but the use of DATEPART may be faster because it uses integer math instead of string comparisons... I just didn't want to have to...

Yeah, you're right... good catch and good eye ... nobody else caught that little boo-boo...

Perfect.  Thank you very much.  That belays my previous suspicions about the new laptops.  And thanks for taking it to the next couple of orders of magnitude!  Always afraid to...

By the way... if you want to know how JacekO's and my code works in some bit of detail, please refer to the following...

http://www.sqlservercentral.com/columnists/jmoden/calculatingworkdays.asp

Thanks for the H/W info, Igor.

Do me a favor please...  run the following code and let me know what times you get back?  The reason I ask is because I'm...

Perfect... thanks for the info!

You bet, Martin... thank you for the feedback.

Hey folks...

Have seen lot's of different code and lot's of different opinions on this thread.  I'd like first to congratulate Grant on producing an article that had such a tremendous...

Thanks, Igor... my solution takes 8.6 seconds on my box first and all times.  It's a little ol' P5 1.8 Ghz with 1 Gig of Ram and twin 80 Gig IDE hard-drives. ...

Yep... Developer's Edition of SQL Server 2000 sp4.  But, like you said, the evironment you run it in makes all the difference in the world for output speed.  OSQL via...

You're welcome...

I've verified that it's available in both SQL Server 2000 and 2005.  Dunno if it will be available in 2008.

You can get a lot more than just the date...

EXEC Master.dbo.xp_GetFileDetails 'C:\AH.aspx'