本文由 资源共享网 – ziyuan 发布，转载请注明出处，如有问题请联系我们！[免费]T3核算现存量整理工具语句.sql
收藏执行就行
Delete From CurrentStock Insert INTO CurrentStock(cWhCode,cInvCode,cFree1,cFree2,iQuantity,iNum,fOutQuantity,fOutNum,fInQuantity,fInNum) Select cWhCode, cInvCode,'null' as cFree1,'null' as cFree2 , inum AS iQuantity, 0 AS iNum, 0 as fOutQuantity, 0 as fOutNum ,0 AS fInQuantity, 0 AS fInNum FROM ia_summary where imonth =(select max(imonth) from ia_summary)
