Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Brazil
    Posts
    1

    Unhappy Unanswered: Arithmetic overflow error

    Hi,

    After 6 months running with the datatype decimal(15,2), every time that I want to update a row, the following message is displayed,

    Microsoft SQL Server:8115[Microsoft][ODBC SQL Server Driver][SQL
    Server]Arithmetic overflow error converting float to data type
    numeric

    and the decimal data is shift to left, like this sample:

    41.61 >> 4161.00
    62.30 >> 623.00

    Anyone can help?

    tks

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Have you run a dbcc check on the table/database?

    Try doing a compare
    select * from tbl where fld = 62.3 to find if it is a presentation or data problem (probably it is the data)

    What happens if you do
    select convert(decimal(15,2),62.3)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •