Home Forums SQL Server 2008 T-SQL (SS2K8) rounding decimal to nearest integer value RE: rounding decimal to nearest integer value

  • June 30, 2015 at 1:53 pm

    #1809285

    Try this

    declare @a decimal(10,2), @b-2 decimal(10,2), @C decimal(6,0), @d decimal(6,0)

    select @a = 5.49 , @b-2 = 5.58

    select CAST(@a as decimal(10,0)),CAST(@b as decimal(10,0))