[概述]

资产盘点表4张卡片内码异常,执行语句修改。

参考语句:

select * into t_assetinvdept_bak20181031 from t_AssetInvDept where FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2') and FProjectID=1003

delete from t_AssetInvDept where FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2')

and FProjectID=1003

insert into t_AssetInvDept select 1003,fassetid,fassetnumber,fdeptid from t_AssetInvDept where FProjectID=1007 and FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2')

select * into t_AssetInvEntry_bak20181031 from t_AssetInvEntry where FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2') and FProjectID=1003

delete from t_AssetInvEntry where FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2') and FProjectID=1003

insert into t_AssetInvEntry select 1003,FAssetID,FAssetNumber,FAssetName,FGroupID,FUnit,FNum,FLocationID ,0,FReCurNum,FCurLocationID,16423, '2017-02-23',FReCurUserID, FReCurDate,FCreateByPrj ,FOSRBInterID, FCurRemark,FReRemark from t_AssetInvEntry where FProjectID=1007 and FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2')