Problems with 'ROUND'

• jassr

  SSC Rookie

  Points: 25

  More actions

  March 30, 2010 at 6:46 am

  #222568

  Hello,

  I have some strange messages. After

  SELECT ROUND(.7545, 0)

  I received: An error occurred while executing batch. Error message is: Przepełnienie arytmetyczne.

  Select round(28/31, 0) gives 0 as result. (In my opinion 1 is correct)

  Select round(28/31, 0) gives 1 as result. (In my opinion 2 is correct)

  Do you know how to solve these problems. Thanks in advance

  Jacek

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  March 30, 2010 at 6:50 am

  #1142144

  Go through the below link where a similar issue was discussed

  http://www.sqlservercentral.com/Forums/Topic890414-338-1.aspx

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• jassr

  SSC Rookie

  Points: 25

  More actions

  March 31, 2010 at 5:03 am

  #1142958

  Thank you for quick reply. I hven't any error messages now. But

  Select round(cast(29/31 AS DECIMAL(10,4)), 0)

  is still

  0

  not 1!!

  Please help me

  Jacek

• nguyennd

  SSCommitted

  Points: 1881

  More actions

  March 31, 2010 at 5:35 am

  #1142982

  Can you uses thia code

  Select round(1.0*29/31,0)

  When 29/31, SQL will use DIV (29 DIV 31) if both number are INTEGER. If you multiple 1.0 before 29, you can resolve your problem

  http://unitech.vn

• jassr

  SSC Rookie

  Points: 25

  More actions

  March 31, 2010 at 7:07 am

  #1143054

  Yes. It's really works.

  Thanks a lot for your help

  Jacek