It really is quite simple.  We want a function that matches the following rules:

* Decide which is the last digit to keep.

* Increase it by 1 if the next...

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

Which is why we are here in thre first place.

Dave J

This is fun.

I read it carefully.

Especially this:

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

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

I was asked for, and supplied the latest iteration.  That's where you find it.

What made you change datatype of the...

Ermm...

select dbo.fn_Bround(2.265,100) union

select dbo.fn_Bround(612.945,100)

---------------------

2.2600

612.9500

(2 row(s) affected)

Yes?

Guys, are you really programmers?

Personally, no.  I'm a DBA Manager.

Now off to the other thread to reply to yet more

David Jackson, you need to thank Sergiy, as he just proved that your function works perfectly to his expectations.

Thanks Sergiy

Dave J

Isn't double precision a synonym of float?

So I believe.

Do you use actually use double precision in the function?

Yes.  Proof once again you do not read these posts carefully.  Go on,...

Your changing the rules again.

So, please use datatypes you're using for your function.

OK.

select (cast(2 as double precision)/ cast(3 as double precision)) * 3

Dave

environment = SQL2000 Query Analyzer

select (cast(2 as float)/ cast(3 as float)) * 3

Result

2.0

I can't test this now, but his "Try harder." comment, when the error was on his part on how he called the function, got to me . Sorry.

Sergiy

you was politely asked to stay out of this thread. The reason you got an error was because you are using Lynns function, which does not take the same...

Certainly.  This uses Double Precision, which I've never heard of in T-SQL until recently, but it still has trouble with certain values. 

Although it does pass...

closest cent

---------------------

.1200

is the result you get when you use 100000

And it is expected.  This is why bankers rounding is also called the round to even method....

This works perfectly as expected for me

set

nocount on

declare @d decimal