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'

Just another way...

SELECT REPLACE(STR(somecol,6),' ','0')

You know what they say... "Tuning makes perfect"   Keeps getting better and better...

Nicely done, Ian... didn't know the OP was doing the kind of stuff he said in a later post.

Heh... could be... the correct answer is "don't sort in a view".