insert into ap_closebill(iID,ID,iType,bPrePay,cCusVen,iAmt_f,iAmt,iRAmt_f,iRAmt,cKm,cXmClass,cXm,cDepCode,cPersonCode,cOrderID,cItemName,cConType,cConID,iAmt_s,iRAmt_s,iOrderType,cDLCode,ccItemCode,RegisterFlag,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,cStageCode,cCoVouchID) select iID,ID,iType,bPrePay,cCusVen,iAmt_f,iAmt,iRAmt_f,iRAmt,cKm,cXmClass,cXm,cDepCode,cPersonCode,cOrderID,cItemName,cConType,cConID,iAmt_s,iRAmt_s,iOrderType,cDLCode,ccItemCode,RegisterFlag,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,cStageCode,cCoVouchID from UFDATA_001_2013..ap_closebills where id not in (select id from ap_closebills) |