asked on

Runtime Err. Arithmetic Overflow Error Converting Numeric to DataType Numeric

Hi,
I'm Trying to update my database with a numeric valule of a particular table. While doing this process I'm getting the runtime error (-2147217833) Arithmetic Overflow error converting Numeric to Datetype Numeric.

The DataBase I'm using is SqlServer. I'm begining a session within that session I'm updating a same table twice, the first time it is getting updated but it fails in the 2nd time.

Can you pls. help me in this regard

Regards

mmusante

It seems like your update is between to different number formats and that in some case the conversion is not possible

(for example converting a Int to a SmallInt)

plese post your update query and the table definition ...

spk2shankar

ASKER

Hi mmusante
thank you for showing interest

My table structure is like this
Table Name - > Remit

Columns
Remit_No Numeric(7),
Remit_Date SmaleDateTime,
Remit_Curr Varchar(3),
Remit_amt Numeric(18,3),
Remit_Batch Numeric(7)

First I'm updating the table with amount at that point of time it is getting updated. Then
I'm updating the table with a query Update Remit set Remit_Batch = 17 where Remit_No = 76584
and Remit_Date = '2004-04-09'

Regards

mmusante

Try changing the date condition to ...
Remit_Date = {d '2004-04-09'}

spk2shankar

ASKER

hi mmusante
thankyou I even tried that, that is not working
regards

Dabas

Hi spk2shankar:
> and Remit_Date = '2004-04-09'
This definitely is wrong.
Have you tried
and Remit_Date = CONVERT(DATETIME, '2004-04-09 00:00:00', 102))

Dabas

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

leonstryker

No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:

Answered acperkins

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

leonstryker
EE Cleanup Volunteer