| Author |
Topic |
|
agipson30
Starting Member
5 Posts |
 Posted - 2013-08-06 : 15:46:12
|
| Hi, My company is in the process of upgrading several SQL 2000 servers to 2008, However, after a successful upgrade of one server we are having a issue ithe the second upgrade. The error is ‘Msg 8114, Level 16, State 5, Line 1Error converting data type nvarchar to numeric.’ I’ve been able to recreate the error with the below code. select ResponseText,CAST(ResponseText as decimal(9,4))from ah_member_responses_detailWhere account = XXXXXXX and ResponseID in (select ResponseID from ah_member_responses Where account = XXXXXXX and Question_ID in (258,2506,46)AND CAST(ResponseText AS DECIMAL(9,4)) <> 0)The last statement is causing the error but on the other upgraded database we do not get the error.Can you help me with why this could be the case. Was something not upgraded correctly?Alonzo Gipson |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
agipson30
Starting Member
5 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
agipson30
Starting Member
5 Posts |
Posted - 2013-08-06 : 16:43:23
|
| 80Alonzo Gipson |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
agipson30
Starting Member
5 Posts |
Posted - 2013-08-06 : 16:49:55
|
| They both have the same version. Also, since we are upgrading from 2000 to 2008 should it tay at (80). We skipped 2005 so we are the last of the dinosaurs.Alonzo Gipson |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
agipson30
Starting Member
5 Posts |
Posted - 2013-08-06 : 16:58:58
|
| Thank you, I changed the compatibility level and no changes and the same error happens.Alonzo Gipson |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
SQL Server 2008 - CAST in Where clause