Home Forums SQL Server 7,2000 T-SQL Conversion failed when converting the varchar value '98.97%' to data type int. RE: Conversion failed when converting the varchar value '98.97%' to data type int.

  • When you declare @percent at the top, did you change it from @percent int to @percent decimal(4,2)?

    If not it will implicitly convert it back to an int, which is why you lose your decimals.