> The bankers Round function prevents this type of error.

It does not.

It prevents some cases of this type of errors.

Very limited cases.

"Convergent Rounding" or "Round to Nearest Even" or "Round Half Even", also called "Banker's rounding", also called "Statistician's rounding" (yep, that's right, statistician's), and many other names is a perfectly...

I did not start personal attacks.

Don't want to be attacked - do not attack.

It does not fail if you do it right, as math school book tells:

Do calculations using 4 digits precision (money datatype) and compare displayed values (2 digits precision).

BTW, taxing authorities...

SELECT @j-2 AS ParameterName, [col_1] AS parameterValue

FROM [table_2] ...

>> You have not proved to me that there is not a case for using a Bankers Round function.

This clearly illustrates your "minor in math".

Non-existence should not be proved.

If...

This is the case where a bankers round function helps, because the only time I have had this fail was when the some of the components was LESS THAN...

You are a brainless moron.

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

Happy with that?

(It does not mean it's my opinion, it's just a reflection...

Bojidar,

if your user is creating an order, and Order Number to be generated by some algorythm how you can make sure 2 users creating 2 orders at the same time...

If you entered the argument again and you did not admit you're wrong what's the point then?

Move to personal insults when you fail again?

Still waiting to see what the Bankers...

Try it.

Not in production, of course.

See how much you can restore.

BTW, because I don't expect many errors during execution of DROP TABLE that transaction gonna be committed before you know...

OK, Lynn, as soon as you admit you were wrong and you can prove something to me (no point to ask for apologi, I guess), lets continue.

You said, midnight event...

I believe you missed the topic "How restore the data from dropped table".

You cannot imagine what kind of queries developers can send.

I did not.

You just cannot get the subject.

You promissed - stay out.

When you have learnt not to take personal point in discussions you'll be allowed to join.

We'll definitely find the common groung with David without your "help".