Member Avatar for KRichardson1127

Hello all!

I'm trying to convert one of my columns in MS SQL Server 2005 from an integer to a decimal field (ex. 59670 ---> 596.70), but I keep receiving an error message:

Msg 8115, Level 16, State 8, Line 1
Arithmetic overflow error converting numeric to data type numeric.


Any suggestions on how to do this???


Thanks in advance!!!

  • 2 Contributors
  • 1 Reply
  • 92 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake

Can you post the table structure? Here is an example of what may cause this:

select Cast((59670.0 / 100.0) as decimal(2,2))

Results in:

Msg 8115, Level 16, State 8, Line 1
Arithmetic overflow error converting numeric to data type numeric.

It appears you're using a number larger than the maximum configured value for that column.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.