Home Forums SQL Server 7,2000 T-SQL Round to Even (aka Banker''s Rounding) - The final function RE: Round to Even (aka Banker''''s Rounding) - The final function

  • David,

    if you are given with number 1.0450000000000001 (or 2/3) but you have only DECIMAL(18,6) storage for this, how can you produce right result from Bankers Rounding?

    Can you post some code please?

    And to see a resolution for the problem with 50/111.111 would be nice as well.

    _____________
    Code for TallyGenerator