You cannot do any better than David's version unless you know the unique key for the table.

Aaron assumed it's Column1 + Column3, but it's probably not.

Lack of information.

David, we all have already passed this track.

2 errors in your test:

1) you're performing implicit conversions without displaying its results;

2) you did not take for the taet values indicated earlier...

What was the datatype of the value you supplied to the function?

Can you show here precise (according to your requirements) representation of 2/3 in that datatype and the way you've...

Rounding is exactly how you represent a shortened version of a number. In other words, they are approximations.

Really?

Did you think a second before writing that?

Have you found answers on...

If you're asking about SQL2000 the answer is "no".

If you're asking about SQL2005 you picked the wrong forum.

You claimed that you did.

But you did not.

I checked the value you supplied - it was 0.66666666.

(2/3) * 3 should be exactly 2.(0)

Right?

Lets' check:

0.66666666 * 3 = 1.99999998

Not as expected.

You...

You definitely never lived in socialist country.

Go to Cuba or North Korea and tell them about choice.

I believe even Russia or China will be something undiscovered for you.

Sorry, David,

I see you're not only bad in math, you're bad in reading.

All your books tell about approximations, roundings, but not representations before rounding.

And your "one cite" cotradicts itself: in...

I wonder where did you find I'm so stubborn about this?

Where did I object using of BR is it defined by somebody as a business rule?

> If I don't like...

> I just think it would be nice for those who need it to have a good quality tool.

So, what's a problem to prove the good quality of the...

So, what all this was about?

You described traditional rounding rule, accepted everywhere as a standard procedure.

I accept this rounding as a valid method and use it.

BR breaks this rule, so...

Half of dollar is goind down, half of dollar is going up - sounds absolutely fair.

Why don't you think I'm doing great job?

Does your opinion depends on amount charged?

It's unfair either to lose or gain extra half cent.

There is a rule - round to the...

If you are happy to be charged more just because rounding function I use produces errors time to time...

You know, I can add a whole lot of actual and possible...

I'll lose both times:

1.0450000000000001

and

1.0449999999999999

will both be rounded down.