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.
roryp 96873
SSCertifiable
Points: 6649
More actions
November 19, 2013 at 11:12 am
#1667510
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.