I am trying to insert 'int' (integer) datatype into a AS400 table. The fields on the AS400 are of type 'S' (numeric). I have tried to cast the data as numeric but I get an error.
Can anyone help?
INSERT INTO ebbillhp (BHNROV, BHCRTDT, BHBILLHWEB, BHUSERID)
VALUES (convert(numeric,@Site), convert(numeric,@Account), @BillCode, @UserName)
I get the following error in SQLServer 2005:
"Msg 8115, Level 16, State 8, Line 1
Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated."