Nope... it doesn't... I tested it.  See my previous...

There's really only one way to get performance out of this code...

Without modification, the  original query/function on only 10,000 rows takes 19 seconds and Antares' takes 17.  On 20,000 rows, the...

Um... I think you really need to use the DBCC proc I told you about as part of normal maintenance, anyway.

Heh... now you understand my world of pain... I've got users that think they know how to write code/design objects and developers that don't.  Ouch!

Use DBCC UPDATEUSAGE... see Books Online for the details... you can do the whole database, a single table, or a single index.

I would suggest not to use T-SQL also for cooking rice and painting walls.

I "paint the walls"...

"Irony"... thanks for the reminder... I gotta iron a shirt for tomorrow's holy war with management 

Well... it depends...

Heh... Oh, I agree with you, Serqiy... no such thing as a "Universal Application".  Maybe they're that "misinformed" or ... not.

Nah, it's gotta be something else.  I'll try to get...

That's what the "" is supposed to do when importing into Excel... it's one of the default settings.  Tell your client the "" is absolutely necessary.

Should have sent this for a Friday poll!!

Didn't know there was such a thing... I'll check it out! ...

Yep, thanks Antares... knew that.  Not entirely sure that's what they were looking for, though.  Really strange question.  I think both Steve and I are right... it was one of...

That's kinda where I went with it... it depends.  But, I think they had something specific in mind... or, like I said, maybe a trick question to determine which "camp" I was...

Dunno, Peter... I can see UDF's being a place where you'd definitely NOT want to use a stored proc... but, I really don't know what they were getting at.  I...

Guess that's what I get when I only ask one question a year, huh?

Heh... yeah... I had a similar reaction as you did, David... I know you can't make it brush...