Viewing 2 posts - 1 through 2 (of 2 total)
Here's my version of Banker's Rounding.
I tried to make it similar to existing ROUND, which can do SELECT ROUND(250, -2). Arithmetic Rounding rounds 250 to 300.
SELECT dbo.f_BankersRound(250, -2) yields 200.000000...
This...
October 9, 2007 at 9:56 am
#740428
Carl,
Your RoundBanker does NOT implement Banker's Rounding correctly.
Because people seem to be using your implementation, I thought I should post this message to warn them.
The problem is that your understanding...
October 8, 2007 at 2:53 pm
#740162