I have the following error when executing a script:
Arithmetic overflow error converting numeric to data type numeric.
I have a table called TBL_ADENDA_ACH
in a development database and I run the following script:
SELECT * FROM TBL_ADENDA_ACH WITH(NOLOCK)
WHERE Num_Referencia= 008888002000552
This works fine, but when executing it in the same table but in the production environment it gives the aforementioned error, I already checked the data types, length, collation but the inconvenience follows.