You are correct... the STR function doesn't appear to be working there...  I'll blame it on installing SP4

Yeah... the definitions on the reference I made are not exactly correct... here's the long post I was talking about... the 3rd post (Andrew) on the first page on the...

Found this to be quick and easy.

That's exactly what I've been ranting about

Thank you very much... always good to see timings on these types of experiments even if they're "unscientific"   And thanks for the feedback...

Great... thanks for the feedback, Magnus...

I created an 8 million row table and have tried all the scenarios you have... I cannot get it to fail in the manner which you speak of.  I think...

Yes, but not for dynamic SQL...

The error that you are getting is becaue you are using EXEC the wrong way to execute dynamic SQL... you have...

EXECUTE @STR

... and it should be...

EXECUTE...

Ah... how rude of me... forgot to post how long my code took... Using SQL Server Developer's Edition (same as Enterprise Edition), sp4, 1.8 Ghz single cpu, 1 Gig RAM,...

p.s.

Heh... looks like David and I got our rounding examples from the same source...

http://en.wikipedia.org/wiki/Bankers%27_rounding#Round-to-even_method

Heh... I've been all through this on one unbelievably long post before and then I struck gold quite by accident... Unbeknowst to most, the STR function does Banker's rounding "auto-magically"... ...

>>Wait..don't tell me both columns are NULLable, too...;-))

Heh... dunno... like I said, they cut off my ability to pry any further... but the way they do things in that particular...

Very cool... thanks for sharing!

Yes, please post the query... chances are, the criteria in the WHERE clause is what's keeping the index from being used...

Heh... you DO have a way with words!  Good thing I had a DBA with the same type of extremely dry humor you do

Can't test it, but that's SO easy!  Way to go, Peter... can't wait to get my hands on 2k5!