I have a stored procedure that updates data in a table.
one of the colums has a data type decimal(6,2)
the stored procedure works if i plug the value 9.9 into that parameter
but if i try any value of 10 or over then it gives this error:
error converting data type numeric to decimal
any ideas why this would be?
i though decimal (6,2) allowed a numbers such as 1234.56