"Does the name "Giordano Bruno" say to you anything?"

Sure it does. Sometimes, the little guy is right and everyone else is wrong, but in this particular case, the rest of...

I took your test case and proved you wrong and you still claim to be correct. As my Dad used to say "If the hole is getting too deep, stop...

You know Skippy, earlier you were making fun of the folks behind this rounding method missing 5th and 6th grade math. I think the problem is that you remained there,...

By the way, this could have been a simple debate on the merits of banker's rounding (there's plenty of room for debate in that area, some of which I'd probably...

"Here comes the diffeence between banking and real world."

Banker's rounding is used in the "real world", whatever that means.

"There is no such thing as precise numbers in real world."

Of course...

That's incorrect, as both floor and ceiling return the same value for non-rounded numbers. Once again, equal numbers are rounded up and down, while another set of numbers aren't rounded...

No one, as those 200 don't require rounding. The 200 is comprised of numbers such as 0.0100, 0.0200, 0.300, etc.

So, we have 200 numbers where no rounding occurs, 9900 where they round...

Will a data-driven subscription not meet your needs?

You can do dots, dashes, etc., but are limited to three total (solid, dot, dash), so it won't work in your situation. The same place also lets you place markers,...

Sergiy, I did that, and it looks fair to me. 9900 values round up, while 9900 values round down. It's quite true that with banker's rounding an individual transaction with...

Sergiy, the point of banker's rounding isn't to be accurate, it's to be fair. The assumption behind it is that if you round 1.235 up to 1.24 every time, that...

Sounds like a self-join. You can either look those up, or post more details so that we can help.

While it's a very awkward workaround, if you have no power to get the source data corrected, you could dump the data into a single fixed-length char column, thus padding...

The problem is that both temp tables and insert statements are very thoroughly documented in BOL, and you haven't shown a single line of code that demonstrates you've even given...

It would help if you tell us what you are trying to accomplish, ideally with DDL for test data creation, your current code, and how you expect the output to...