Sergiy, you also are applying the Bankers round function incorrectly.  Your number, $1.04572, rounded to 2 decimal places will round to 1.05 using both methods.  The Bankers round looks at...

One example does not prove the point.  Look back further in these posts.  Your own test setup, coded by David M. and run by several of us shows the Bankers Round...

Either you can prove your point with out going through "twenty (or five or ten or how ever many)questions" or you can't.  Fish or cut bait, prove your point in...

Sergiy, no more questions and answers.  This is the "fish or cut bait" time.  Prove your point or concede.

Yes.  Now, stop dragging it out, and just prove your point, if you can.

I can't answer your question if I don't know the requirements.  That is why the answer to your question is "It Depends".  No requirements, no answer beyond that.

I am staying...

What answer is wrong?  The one that states It Depends or the one where this has no relevance to discussion about rounding.  You talk in half sentences and abstractions that...

The answer to your question: It Depends.  It depends on what you are tracking, why you are tracking it, so you can determine the approriate way to track it.

So that...

And you have been asked what does this have to do with rounding?

You obviously don't know how to do anything but attack people that disagree with you.  And your twisting of the phrase "minor in mathematics" is so tiring.  All that means...

I'll check with my co-worker. He does a lot of our SSIS package development and we have talked about standards, but I don't know if we ever got to the...

That version of SQL Server 2005 does not have SP 2 installed.  In the @@version, the service pack 2 mentioned, I believe, is for the OS you are running on. ...

Sergiy,

You must be living in your own world.  Anyone who takes the time to read all 126+ posts will come to the conclusion that we all gave up on you. ...

As another of the 5, here are my results of ten runs (sorry if it doesn't fit on one screen or wraps):

InitialTotal                            ConvergentTotal                         Traditionaltotal                        TotalRecords ConvergentCountDown ConvergentCountUp ConvergentCountSame ConvergentDifferene TraditionalCountDown...

Forgot about DATABSEPROPERTYEX, another good catch.