Home Forums SQL Server 2008 SQL Server 2008 - General Arithmetic overflow error converting nvarchar to data type numeric. RE: Arithmetic overflow error converting nvarchar to data type numeric.
duro654321
Mr or Mrs. 500
Points: 572
More actions
October 13, 2012 at 12:51 pm
#1548907
i ran "update table set price = price * cast(1.1 as numeric(10,4))" and that worked pretty well
thanks! 🙂