Error converting data type nvarchar to numeric.

Last Post 14 Jan 2010 08:05 AM by JASBRYDEN. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
JASBRYDEN
New Member
New Member

--
13 Jan 2010 05:31 AM
Hi

This is the code that I have

update FTFHeavyService
set invoiceno=invoice#,
materialcost=convert(decimal(10,2),material),
labourcost=convert(decimal(10,2),labour),
totalcost=convert(decimal(10,2),total)
from FTFHeavyService
left join [MaterialsUsed Tbl] on
jobcard#=jobcardno

but I am getting this error all the time

Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type nvarchar to numeric.


Any idea as to what is wrong with my code ??
JASBRYDEN
New Member
New Member

--
14 Jan 2010 08:05 AM
Thanks !!!!

Those people have some cleaning up of that data.


Thanks for the help !!!!

I have stuff like

US2..3
-2.40-
NIL

that is the type of data I am seeing in those tables.

Thanks again


Acceptable Use Policy
---