错误:将表达式转换为数据类型nvarchar的算术溢出错误。
UPDATE [dbo].ForecastAccuracyKeyAccounts
SET ThreeMonthPercent = ((Actual - ThreeMonthForecast) / Actual) * 100, SixMonthPercent = ((Actual - SixMonthForecast) / Actual) * 100,
NineMonthPercent = ((Actual - NineMonthForecast) / Actual) * 100
WHERE Actual != 0
因为我用实际除以,所以我要确保实际不等于零。但是,当我在WHERE子句中添加语句时,我无法摆脱该错误。
也许尝试 ISNULL
UPDATE [dbo].ForecastAccuracyKeyAccounts
SET ThreeMonthPercent = ((Actual - ISNULL(ThreeMonthForecast,0)) / Actual) * 100,
SixMonthPercent = ((Actual - ISNULL(SixMonthForecast,0)) / Actual) * 100,
NineMonthPercent = ((Actual - ISNULL(NineMonthForecast,0)) / Actual) * 100
WHERE Actual != 0
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句