So, you two agree on what?

Which result of Banking Rounding of 612.945 is right and which is wrong:

612.94 or 612.95 ?

Is there an implementation of the BR function which works...

Another David,

How hard is that to follow?

I use "him" not to be prosecuted for bigamy.

Unfortunately, computers use base 2.

When you'll build computer using base 3 don't forget to inform us about this remarkable achievement.

Thanks.

Two Davids, can you agree between you two:

what is right and what is wrong?

It's not me arguing anymore.

It's you 2 fighting each other.

No, you did not.

You sent 2 numbers, not a 1 fraction.

And you never specified it's a fraction.

Yes, you can rewrite it "to accept a chararacter type, parsing the two integers...

So, you just cannot get your Bakers Rounding work correctly for 612.945.

That's truly fun!

As David Jackson said here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=370393&p=1

SELECT dbo.fn_BRound(654.945,100) -- Wrong - 654.95

So, you're wrong.

It his words, not mine!

Sorry, Jeff,

you are passing here 2 parameters: int 2 and int 3.

I don't see anywhere you passing 2/3

Even if you meant to pass result of that function (forget about...

Jeff, any practical use of these words you posted to cover your error?

Do you actually pass formula to functions or just a value stored in some cells in memory?

Yes, 2/3...

I'm not sure if I'm an idiot (very professional behaviour from your side, bravo!), but you are definitely a lier.

From your link you suggested me to read carefully:

The corrected Function

CREATE...

Which function did you use?

With decimals of with floats?

Last time you were talking about FLOATs.

Changing rules again?

Can you finally decide which version of the function to use to receive consistantly...

Sorry Jeff,

you need to take some essential course about computing.

To pass any value to any function you need to place it in memory.

Computer's memory (even memory of all computers in...

Really?

Now please give me result of BR for your beloved PRECISE value 2.265

Or 612.945

Please prove that your function works as expected for these values.

Can you do it?

Is this function to...

David,

simple question:

Do you supply precise values to BR function?

Yes or no?

Does this function accept imprecise input parameters?

Yes or no?

If yes - which way do you use to supply imprecise...

I read it carefully.

Especially this:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=370393&p=5

What made you change datatype of the input parameter?

Don't remember?

Read the topic from the beginning and refresh your memory.

FLOAT version did not work. And it still...