求救,存儲過程更改數據時數據偶爾會除以1000

Question

如果lz描述无误，只能用RWPT解释了

Answer 1

前一句插入出库日志都没问题
后一句就错误
UPDATE Plan_Stock Set Plan_QTY = a.plan_qty - b.sum_qty FROM plan_stock as a,#Plan_Part_Stock as b  
Where   ltrim(rtrim(isnull(a.part_id,'')))=ltrim(rtrim(isnull(b.part_id,''))) and 
ltrim(rtrim(isnull(a.wh_id,'')))=ltrim(rtrim(isnull(b.wh_id,''))) and 
ltrim(rtrim(isnull(a.location_id,'')))=ltrim(rtrim(isnull(b.location_id,''))) and 
ltrim(rtrim(isnull(a.plan_no,''))) =ltrim(rtrim(isnull(b.plan_no,''))) and 
ltrim(rtrim(isnull(a.lot_no,'')))=ltrim(rtrim(isnull(b.lot_n