? on Rounding to the nearest integer

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  March 3, 2022 at 8:47 pm

  Go to Answer

  #3992684

  Hi,

  I'm trying to figure out how to round to the nearest integer .

  So for example if the number is >=9.5 it shows 10. if <9.5 it show 9

  Thanks

   

• irgp

  SSC Journeyman

  Points: 80

  More actions

  March 3, 2022 at 9:12 pm

  Answer

  #3992703

  Look up SQL Server numerical functions: https://docs.microsoft.com/en-us/sql/t-sql/functions/mathematical-functions-transact-sql?view=sql-server-ver15

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  March 3, 2022 at 9:13 pm

  #3992705

  Yes, Thank You just found i!!