> 1/8th of the integer 1 is precisely .125, no matter how many zeroes you want to tack onto the end of it.

Are you sure 1/8 = 0.125?

Try this:...

David, do you actually understand the stuff you are writing about?

What does it mean:

the result is "precisely" halfway between two valid numbers, based on the desired precision

?

It's good you used...

Once again:

it's a professional forum. We are discussing not me or you, we discussing Bankers Rounding.

Try to behave as a professional.

If you are agree what is the point of the argument then?

If there are no precise numbers - then there are no "not rounded numbers". Every number is rounded because...

Are you talking about counting units or rounding shares?

It does not require any rounding until you start share.

But what do you share?

0.125 of apple - what does it mean? 0.125...

Whoo-hoo!

Finally you agreed that there is no such thing as precise number!

Every "precise" number is an expression of infinite approximation from the range of infinite number of values.

Well done!

JacekO, it's you who cannot get the point for such a long time.

Did you answer for youself the question about midnight event?

It's everything what happened between "zero" moment of time...

Exactly!

But did you get what you just said?

Number 0.125 shows that you've got enough for 0.125 but not enough for 0.126.

The real value behind that number is somewhere between 0.125...

Too bad for you.

0.999... is not exactly the same as 1. It approximates to 1, it's infinitely close to 1 but it's not exactly 1.

I told you this from the...

When you step on scales you've got receipt for your weight: say 84.3 kg.

Not 84 and 1/3. Right.

Can you guarantee that you actual weight is exactly 84.3, not 84 and...

So, money is just some king of social contract. Nothing more.

It's a reflection of how much do you believe Uncle Sam.

Believe me, I witnessed several times how that what used...

Peter,

what is the money?

What do those papers and metal pieces mean?

What makes one piece of paper equivalent to 50 identical pieces but with different picture printed on it?

So, what is...

If you know what to do so well, why wouldn't you do it?

Create table UDF and supply changed values as parameters to it.

Do your aggregations from the values returned by this UDF.

David, just a quote from the article you referenced:

Now look at .99999999..... which is equal to 9/9 = 1.

So, if .99999999..... = 1 then 1 = .99999999.....

Right?

Well, now turn...