--将材料出库单传递到中间库(委外订单不受约束) if exists (select * from sysobjects where id = object_id('dbo.usp_transrdrecord11') ) drop procedure dbo.usp_transrdrecord11 go Create PROCEDURE usp_transrdrecord11 @v_start datetime, --开始时间 @v_end datetime --结束时间 as select Id into #t_01 from rdrecord11 r where (dnmaketime>=@v_start and dnmaketime <= @v_end and ISNULL(cDefine5,0) = 0) or (exists (select Id from RdRecord01 where cBusType='委外加工' and ID=r.ID) ) if @@ROWCOUNT=0 return --delete from wtu..rdrecord11 where exists (select id from #t_01) --delete from wtu..rdrecords11 where exists (select id from #t_01) delete from wtu..rdrecord11 where exists (select id from #t_01 where ID=wtu..rdrecord11.ID) delete from wtu..rdrecords11 where exists (select id from #t_01 where ID=wtu..rdrecords11.ID) insert into wtu..RdRecord11 (ID, bRdFlag, cVouchType, cBusType, cSource, cBusCode, cWhCode, dDate, cCode, cRdCode, cDepCode, cPersonCode, cPTCode, cSTCode, cCusCode, cVenCode, cOrderCode, cARVCode, cBillCode, cDLCode, cProBatch, cHandler, cMemo, bTransFlag, cAccounter, cMaker, cDefine1, cDefine2, cDefine3, cDefine4, cDefine5, cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, dKeepDate, dVeriDate, bpufirst, biafirst, iMQuantity, dARVDate, cChkCode, dChkDate, cChkPerson, VT_ID, bIsSTQc, cDefine11, cDefine12, cDefine13, cDefine14, cDefine15, cDefine16, cPsPcode, cMPoCode, gspcheck, ipurorderid, iproorderid, iExchRate, cExch_Name, bOMFirst, bFromPreYear, bIsLsQuery, bIsComplement, iDiscountTaxType, ireturncount, iverifystate, iswfcontrolled, cModifyPerson, dModifyDate, dnmaketime, dnmodifytime, dnverifytime, bredvouch, bmotran, iFlowId, cPZID, cSourceLs, cSourceCodeLs, bHYVouch, iPrintCount, csysbarcode, cCurrentAuditor, cCheckSignFlag ) select r.ID, bRdFlag, cVouchType, cBusType, cSource, cBusCode, cWhCode, dDate, cCode, cRdCode, cDepCode, cPersonCode, cPTCode, cSTCode, cCusCode, cVenCode, cOrderCode, cARVCode, cBillCode, cDLCode, cProBatch, cHandler, cMemo, bTransFlag, cAccounter, cMaker, cDefine1, cDefine2, cDefine3, cDefine4, cDefine5, cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, dKeepDate, dVeriDate, bpufirst, biafirst, iMQuantity, dARVDate, cChkCode, dChkDate, cChkPerson, VT_ID, bIsSTQc, cDefine11, cDefine12, cDefine13, cDefine14, cDefine15, cDefine16, cPsPcode, cMPoCode, gspcheck, ipurorderid, iproorderid, iExchRate, cExch_Name, bOMFirst, bFromPreYear, bIsLsQuery, bIsComplement, iDiscountTaxType, ireturncount, iverifystate, iswfcontrolled, cModifyPerson, dModifyDate, dnmaketime, dnmodifytime, dnverifytime, bredvouch, bmotran, iFlowId, cPZID, cSourceLs, cSourceCodeLs, bHYVouch, iPrintCount, csysbarcode, cCurrentAuditor, cCheckSignFlag from RdRecord11 r where exists(select ID from #t_01 t where t.ID=r.ID) --------------------------------------------- insert into wtu..RdRecords11 ( AutoID, r.ID, cInvCode, iNum, iQuantity, iUnitCost, iPrice, iAPrice, iPUnitCost, iPPrice, cBatch, cObjCode, cVouchCode, cInVouchCode, cinvouchtype, iSOutQuantity, iSOutNum, coutvouchid, coutvouchtype, iSRedOutQuantity, iSRedOutNum, cFree1, cFree2, iFlag, iSQuantity, iSNum, iFNum, iFQuantity, dVDate, iTrIds, cPosition, cDefine22, cDefine23, cDefine24, cDefine25, cDefine26, cDefine27, cItem_class, cItemCode, cName, cItemCName, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, cBarCode, iNQuantity, iNNum, cAssUnit, dMadeDate, iMassDate, cDefine28, cDefine29, cDefine30, cDefine31, cDefine32, cDefine33, cDefine34, cDefine35, cDefine36, cDefine37, iMPoIds, iCheckIds, cBVencode, bGsp, cGspState, cCheckCode, iCheckIdBaks, cRejectCode, iRejectIds, cCheckPersonCode, dCheckDate, cMassUnit, cMoLotCode, iMaterialFee, iProcessCost, iProcessFee, dMSDate, iSMaterialFee, iSProcessFee, iOMoDID, bFilled, bChecked, iOMoMID, cmworkcentercode, bLPUseFree, iRSRowNO, iOriTrackID, coritracktype, cbaccounter, dbKeepDate, bCosting, bVMIUsed, iVMISettleQuantity, iVMISettleNum, cvmivencode, iInvSNCount, cwhpersoncode, cwhpersonname, iMaIDs, cserviceoid, cbserviceoid, iinvexchrate ) select AutoID, r.ID, cInvCode, iNum, iQuantity, iUnitCost, iPrice, iAPrice, iPUnitCost, iPPrice, cBatch, cObjCode, cVouchCode, cInVouchCode, cinvouchtype, iSOutQuantity, iSOutNum, coutvouchid, coutvouchtype, iSRedOutQuantity, iSRedOutNum, cFree1, cFree2, iFlag, iSQuantity, iSNum, iFNum, iFQuantity, dVDate, iTrIds, cPosition, cDefine22, cDefine23, cDefine24, cDefine25, cDefine26, cDefine27, cItem_class, cItemCode, cName, cItemCName, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, cBarCode, iNQuantity, iNNum, cAssUnit, dMadeDate, iMassDate, cDefine28, cDefine29, cDefine30, cDefine31, cDefine32, cDefine33, cDefine34, cDefine35, cDefine36, cDefine37, iMPoIds, iCheckIds, cBVencode, bGsp, cGspState, cCheckCode, iCheckIdBaks, cRejectCode, iRejectIds, cCheckPersonCode, dCheckDate, cMassUnit, cMoLotCode, iMaterialFee, iProcessCost, iProcessFee, dMSDate, iSMaterialFee, iSProcessFee, iOMoDID, bFilled, bChecked, iOMoMID, cmworkcentercode, bLPUseFree, iRSRowNO, iOriTrackID, coritracktype, cbaccounter, dbKeepDate, bCosting, bVMIUsed, iVMISettleQuantity, iVMISettleNum, cvmivencode, iInvSNCount, cwhpersoncode, cwhpersonname, iMaIDs, cserviceoid, cbserviceoid, iinvexchrate from RdRecords11 r where exists(select ID from #t_01 t where t.ID=r.ID) --释放临时表 drop table #t_01