Arithmetic overflow error converting numeric to data type numeric

My guess is that you’re trying to squeeze a number greater than 99999.99 into your decimal fields. Changing it to (8,3) isn’t going to do anything if it’s greater than 99999.999 – you need to increase the number of digits before the decimal. You can do this by increasing the precision (which is the total number of digits before and after the decimal). You can leave the scale the same unless you need to alter how many decimal places to store. Try decimal(9,2) or decimal(10,2) or whatever.

You can test this by commenting out the insert #temp and see what numbers the select statement is giving you and see if they are bigger than your column can handle.

Related Posts:

  1. Rename column SQL Server 2008
  2. Efficiently convert rows to columns in sql server
  3. T-SQL split string based on delimiter
  4. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  5. SQL Server WITH statement
  6. SQL Server Insert if not exists
  7. SQL Server: Invalid Column Name
  8. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  9. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  10. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  11. Sql query to insert datetime in SQL Server
  12. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  13. Bulk load data conversion error (truncation)
  14. Can I use multiple “with”?
  15. Backup a single table with its data from a database in sql server 2008
  16. How can I group by date time column without taking time into consideration
  17. Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
  18. Filter data based on date in sql
  19. Varchar invalid for Sum operator
  20. Unknown column in ‘field list’ error on MySQL Update query
  21. The wait operation timed out. ASP
  22. When should I use CROSS APPLY over INNER JOIN?
  23. Insert Data Into Temp Table with Query
  24. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  25. SQL SELECT WHERE field contains words
  26. T-SQL split string
  27. Using group by on multiple columns
  28. Nested select statement in SQL Server
  29. What’s the difference between VARCHAR and CHAR?
  30. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  31. How to split the name string in mysql?
  32. Sql Server equivalent of a COUNTIF aggregate function
  33. Column name or number of supplied values does not match table definition
  34. How to Select Top 100 rows in Oracle?
  35. Simple PHP Pagination script
  36. CREATE VIEW must be the only statement in the batch
  37. SQL Server FOR EACH Loop
  38. ORA-12560: TNS:protocol adaptor error
  39. How can I select the first day of a month in SQL?
  40. SQL – HAVING vs. WHERE
  41. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  42. How can I delete using INNER JOIN with SQL Server?
  43. MySQL combine two columns into one column
  44. How to SUM two fields within an SQL query
  45. DateTime2 vs DateTime in SQL Server
  46. ORA-01861: literal does not match format string
  47. Difference between numeric, float and decimal in SQL Server
  48. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  49. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  50. How do I query for all dates greater than a certain date in SQL Server?
  51. How to concatenate text from multiple rows into a single text string in SQL Server
  52. Count(*) vs Count(1) – SQL Server
  53. Remove duplicate rows in MySQL
  54. I want to use CASE statement to update some records in sql server 2005
  55. “You tried to execute a query that does not include the specified aggregate function”
  56. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  57. How to round down to nearest integer in MySQL?
  58. How do I reset a sequence in Oracle?
  59. Query to convert from datetime to date mysql
  60. MySQL error: key specification without a key length
  61. SQL: Two select statements in one query
  62. Check if MySQL table exists without using “select from” syntax?
  63. mysql update column with value from another table
  64. what is the difference between triggers, assertions and checks (in database)
  65. Replacing NULL with 0 in a SQL server query
  66. SQL Server dynamic PIVOT query?
  67. How to delete from multiple tables in MySQL?
  68. How to copy a row and insert in same table with a autoincrement field in MySQL?
  69. Error converting data type varchar
  70. I want to use CASE statement to update some records in sql server 2005
  71. What does Include() do in LINQ?
  72. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  73. Get everything after and before certain character in SQL Server
  74. LEFT function in Oracle
  75. What are database constraints?
  76. Postgresql column reference “id” is ambiguous
  77. Inner Joining three tables
  78. How do I view the Explain Plan in Oracle Sql developer?
  79. ORA-01779: cannot modify a column which maps to a non key-preserved table
  80. SQLite string contains other string query
  81. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  82. Sorting search results by taxonomy terms
  83. How to properly sanitize strings without $wpdb->prepare?
  84. WordPress SQL LIKE request doesn’t work for fields with special symbols
  85. posts_where Fails with More than One Custom Field in Query
  86. WordPress database error: You have an error in your SQL syntax
  87. Restose content from revisions – sql query
  88. Better way to migrate to server?
  89. Inner Join user tables to select users with roles
  90. $wpdb->prepare with LIKE returning blank array instead of rows
  91. Removing posts by sql
  92. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  93. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  94. Help me SELECT thumbnail from SQL and use
  95. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  96. Creating a “forum” – showing last post or last commented post
  97. Replace Unwanted Space in Post Content URL
  98. SQL to transform all email addresses in my DB in lowercase [closed]
  99. How to write inner join using posts_clauses?
  100. This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1

Leave a Comment