geeting错误:将数据类型nvarchar转换为数值时出错.

问题描述

SELECT DISTINCT
                      T0.Jobcard, T0.Operator, T1.JobCardQty, T0.Mouldqty, T0.Process, T0.Profilename, T0.Remark, T0.Date, T1.U_od, T0.Supervisor, T2.SizeFrom,
                      T2.SizeTo, (T0.Mouldqty * T2.Rate + T2.DieSetting) AS Cost, T3.Division
FROM         SAPProduction.ProductionData AS T0 INNER JOIN
                      SAPProduction.RateChartData AS T1 ON T0.Jobcard = T1.Jobcard COLLATE SQL_Latin1_General_CP850_CI_AS INNER JOIN
                      SAPProduction.ProductionRateTable AS T2 ON T0.Process = T2.Process INNER JOIN
                      SAPProduction.ProductionMaterialMaster AS T4 ON T2.Process = T4.process INNER JOIN
                      SAPProduction.ProductionDivisionMaster AS T3 ON T2.ChartType = T3.fid
WHERE     (T1.U_od BETWEEN T2.SizeFrom AND T2.SizeTo)

推荐答案

这篇关于geeting错误:将数据类型nvarchar转换为数值时出错.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！