Home Forums SQL Server 2008 SQL Server 2008 Administration Conversion failed when converting the varchar value '099.0' to data type int. RE: Conversion failed when converting the varchar value '099.0' to data type int.

  • February 26, 2014 at 7:29 am

    #1692271

    Perhaps you could declare a variable as DECIMAL(10,2) then set the INT column to the value in the decimal variable... a 2 step conversion.