Google

Tuesday, November 29, 2011

MSSQL ERROR - Arithmetic overflow error converting numeric to data type numeric

ERROR - Arithmetic overflow error converting numeric to data type numeric
 

CONVERT (decimal(5 , 2), 1) / CONVERT (decimal(5 , 2), myField)
the error typically occurs when you are trying to pass a numeric value that is too large...
CONVERT (decimal(10 , 2), 1) / CONVERT (decimal(10 , 2), myField) ==Fixed

No comments:

Post a Comment