I am getting the following error when trying to run an update query: Error Converting Data Type Varchar to Float. Here is the code I'm using...
set COST = xdmp.new_cost
--set COST = case isnumeric(xdmp.new_cost) when 1 then cast(xdmp.new_cost as FLOAT) else null end
join TB_PARTS on TB_STYLES.STYLE_ID = TB_PARTS.STYLE_ID
join xdmp on TB_STYLES.STYLE = xdmp.[fms #]
TB_PARTS.CONTACT_ID = 23
The data in the xDMP table was imported from an Excel spreadsheet using DTS. The data types for the TB_PARTS.COST field and the xDMP.New_Cost are both showing FLOAT.
Not sure what I'm doing wrong. any suggestions to help fix the issue would be great.