And wether the earth is the center of the universe or not has no bearing on the use or validity of the Bankers Round function.  They are not related in any...

Sorry, again, you failed to answer all my questions.

Also, your numbers were wrong: go back and read.  You collected 0.50 in taxes, and you need to distribute these amount to three taxing authorities: .250, .125, .125.  .25  +...

I'm not trying to prove it is invalid.  All rounding methods have some issue some where.  Will you agree with that statement?

I am not proposing that Bankers Rounding be used...

Okay, here is your task:

You have collected 0.50 in taxes from the sale of 1 or more items (doesn't matter how many).  You have to distribute these funds to three...

Your post:

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

I believe the names "Catholic Church" and "Holy Inquisition" were not less at that times than IBM, IEEE, Microsoft and all...

Sergiy, it was the way you put it, not the way I put it.  As I tell my kids, it is the tone or inclination you put on words as...

I made ONE statement about your personality, I did not continously attack you in post after post, and I even apologized in a private email about that statement (something you...

This:

You should not prove you did not commit a crime.

They must prove you did.

If they cannot provide an evidence - there are no evidences.

This depends on where you are being...

And do you admit that the standard rounding function also fails on occasion (look at my example)?  You would have to apply "some work around to fix its results" (your...

Now i need more info.  DDL for the tables and some sample data plus expected output based on the sample data.

With that, either I or someone else out there will...

>> If you wish to continue the academic argument, please find someone else who is interested in such an argument.

You mean who is smart enough and can understand this...

Actually, this :

You are a brainless moron.

Please don't take it as an insult, it's just an observation on my part.

is an insult no matter how you put it.  I...

I have never resorted to insults (unless you you are meaning my comment about a type a personality, taht was not an insult but an observation on my part), although...

Can't think of why you would want to do that, but if I had a need to do something like that, it really sounds like dynamic sql is the only...