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:27 pm
#1548902
the value of the price field is:
.05
.25
.6
1
1.25
150.7
250
265.75
etc
so if there are no items price that are greater than $1000 then i would use the following: ?
update field set price = price * cast(1.1 as numeric(1000,7))