Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shiyam198
Yak Posting Veteran
94 Posts |
 Posted - 2010-03-29 : 22:12:23
|
| I am getting this error - "Arithmetic overflow error converting nvarchar to data type numeric, when I am running the sql script.select comment_note, Customer_No, customer_idfrom AspenData.dbo.Customerslimitedbydate with(nolock)left join AspenShowProdMar29.dbo.ts_customer with(nolock)on AspenData.dbo.Customerslimitedbydate.customer_no = AspenShowProdMar29.dbo.ts_customer.customer_reference_codewhere (CAST(AspenData.dbo.Customerslimitedbydate.comment_note AS nvarchar(4000)) <> '') and (CAST(AspenData.dbo.Customerslimitedbydate.comment_note AS nvarchar(4000)) is not null)Not sure what is causing this error.Any help is much appreciated.- Shiyam |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-03-29 : 22:18:43
|
check your query where you are comparing a string data type to a numeric data typemost probably thison AspenData.dbo.Customerslimitedbydate.customer_no = AspenShowProdMar29.dbo.ts_customer.customer_reference_code
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Arithmetic overflow error converting nvarchar to d
Tara Kizer