The real killer would be the presence of a clustered index or a great many non-clustered indexes.  Unless you use SELECT/INTO, the Simple Recovery Mode won't be of much help...

What do you want the CSV file to look like for column headers?

Would be a bit more helpful if you posted the code so we can see what you did wrong.  For example, in the SELECT you posted in your message, the...

I, for one, have enjoyed the simple yet educated rhetoric spawned by this editorial. The reason for most of the passion displayed is likely because of personal experience and...

Heh... yeah... how silly of me to think it might have been an SQL Server question on an SQL Server forum... not enough coffee and I missed that... thanks, Julie.

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.