I'm thinking that we should keep "real" religion out of this...

By the way, I did find my iron

Yep... strayed just a bit... I think Peter meant "would a CLR be an appropriate place to build a function"?  If not, that's the way I took it and I...

Outstanding!  Thanks for the feedback!

Agreed... WHEN you have an application... and if you save the data into a table with the correct decimal data type, takes no time at all.

Thanks Ken... haven't had the opportunity to work with 2005 to any great extent.  Appreciate the time you took to explain it.

You bet, Pam.  Let us know how it works out.

Yep... it is strange... the function does Index Seeks on the 2 part index and the outer Select that uses the function does and Index Scan because it's looking at...

I know squat about CLR's... can you call a proc in a CLR?

Ah... sorry.  Didn't read the whole thing.

Actually, I did that... and a couple of other renditions, as well. 

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.