Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00

This generates an Arithmetic Overflow because it is trying to implicitly cast the Val column to a NUMERIC(3,2), which naturally will overflow on a 2-digit value like 10.

It’s using NUMERIC(3,2) as the target type and size because that is the smallest numeric that 9.00 appears to fit into.

The solution, of course, is to use explict CASTing instead of doing it implicitly

Related Posts:

  1. T-SQL split string based on delimiter
  2. Can I use multiple “with”?
  3. How can I group by date time column without taking time into consideration
  4. Varchar invalid for Sum operator
  5. Selecting COUNT(*) with DISTINCT
  6. What is a stored procedure?
  7. Self Join to get employee manager name
  8. How do I UPDATE from a SELECT in SQL Server?
  9. SQL query to select dates between two dates
  10. When should I use CROSS APPLY over INNER JOIN?
  11. How can I do an UPDATE statement with JOIN in SQL Server?
  12. T-SQL split string
  13. Rename column SQL Server 2008
  14. Efficiently convert rows to columns in sql server
  15. SQL Query with NOT LIKE IN
  16. How do I escape a single quote in SQL Server?
  17. How do I escape a single quote in SQL Server?
  18. IDENTITY_INSERT is set to OFF – How to turn it ON?
  19. Column name or number of supplied values does not match table definition
  20. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  21. SQL Server FOR EACH Loop
  22. SQL Server WITH statement
  23. DateTime2 vs DateTime in SQL Server
  24. SQL Server Insert if not exists
  25. SQL Server: Invalid Column Name
  26. How can I get column names from a table in SQL Server?
  27. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  28. How to parse XML data in SQL server table
  29. What is the equivalent of ‘describe table’ in SQL Server?
  30. Error converting data type varchar to float
  31. Arithmetic overflow error converting numeric to data type numeric
  32. I want to use CASE statement to update some records in sql server 2005
  33. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  34. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  35. Sql query to insert datetime in SQL Server
  36. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  37. SELECT DISTINCT on one column
  38. Exclude a column using SELECT * [except columnA] FROM tableA?
  39. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  40. TSQL PIVOT MULTIPLE COLUMNS
  41. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  42. Bulk load data conversion error (truncation)
  43. SQL “select where not in subquery” returns no results
  44. Equivalent of Oracle’s RowID in SQL Server
  45. Get current year in TSQL
  46. Is it possible to specify condition in Count()?
  47. SQL Server dynamic PIVOT query?
  48. Backup a single table with its data from a database in sql server 2008
  49. Error converting data type varchar
  50. Temporary table in SQL server causing ‘ There is already an object named’ error
  51. I want to use CASE statement to update some records in sql server 2005
  52. How to calculate age (in years) based on Date of Birth and getDate()
  53. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  54. Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
  55. “select * into table” Will it work for inserting data into existing table
  56. SUM OVER PARTITION BY
  57. Filter data based on date in sql
  58. Update query using Subquery in Sql Server
  59. Unknown column in ‘field list’ error on MySQL Update query
  60. SQL Inner-join with 3 tables?
  61. MySQL create table if not exists and insert record only if table was created
  62. ORA-00907: missing right parenthesis
  63. Case statement in MySQL
  64. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  65. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  66. How Stuff and ‘For Xml Path’ work in SQL Server?
  67. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  68. Oracle SELECT TOP 10 records
  69. must appear in the GROUP BY clause or be used in an aggregate function
  70. How can I return pivot table output in MySQL?
  71. The multi-part identifier could not be bound
  72. MySQL syntax for Join Update
  73. SQLite – UPSERT *not* INSERT or REPLACE
  74. how to drop partition without dropping data in MySQL?
  75. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  76. Simple way to calculate median with MySQL
  77. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  78. Error 1046 No database Selected, how to resolve?
  79. What is it exactly a BLOB in a DBMS context
  80. Oracle SQL: Update a table with data from another table
  81. How to SUM and SUBTRACT using SQL?
  82. What represents a double in sql server?
  83. MySQL – UPDATE multiple rows with different values in one query
  84. How to create a MySQL hierarchical recursive query?
  85. Subtract one day from datetime
  86. updating table rows in postgres using subquery
  87. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  88. Is there a coalesce-like function in Excel?
  89. How do I count unique items in field in Access query?
  90. How to select the last record of a table in SQL?
  91. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  92. What is a postgres superuser
  93. “This SqlTransaction has completed; it is no longer usable.”… configuration error?
  94. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  95. Auto-update tables from database
  96. dbDelta not creating table (yes, once more)
  97. How to export 2 week’s worth of posts
  98. SQL – JOIN last child
  99. wpdb prepare without placeholder
  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

tech