刷库修复单位原创
htv
23人赞赏了该文章
76次浏览
未经作者许可，禁止转载编辑于2024年09月15日 18:15:48
慢慢刷吧
declare @newdl int,@wlbm varchar(20) set @newdl=156115 set @wlbm='3101000357' update a set a.FBASEUNITID=@newdl from t_BD_MaterialBase a,T_BD_MATERIAL b where a.FMATERIALID=b.FMATERIALID and b.FNUMBER=@wlbm update a set a.FREFCOST=@newdl,a.FSTOREUNITID=@newdl from t_BD_MaterialStock a,T_BD_MATERIAL b where a.FMATERIALID=b.FMATERIALID and b.FNUMBER=@wlbm update a set a.FSALEUNITID=@newdl,a.FSALEPRICEUNITID=@newdl from t_BD_MaterialSale a,T_BD_MATERIAL b where a.FMATERIALID=b.FMATERIALID and b.FNUMBER=@wlbm update a set a.FSUBCONUNITID=@newdl,a.FSUBCONPRICEUNITID=@newdl from t_bd_MaterialSubcon a,T_BD_MATERIAL b where a.FMATERIALID=b.FMATERIALID and b.FNUMBER=@wlbm update a set a.FPURCHASEUNITID=@newdl,a.FPURCHASEPRICEUNITID=@newdl from t_bd_MaterialPurchase a,T_BD_MATERIAL b where a.FMATERIALID=b.FMATERIALID and b.FNUMBER=@wlbm update a set a.FPRODUCEUNITID=@newdl,a.FBOMUNITID=@newdl,a.FMINISSUEUNITID=@newdl from t_BD_MaterialProduce a,T_BD_MATERIAL b where a.FMATERIALID=b.FMATERIALID and b.FNUMBER=@wlbm