SELECT * into T_AR_RECEIVEBILLENTRY_bak FROM T_AR_RECEIVEBILLENTRY
WHERE FPURPOSEID IN (SELECT fid FROM T_CN_RECPAYPURPOSE WHERE FFINMANEGEMENT = '1')and fid in(103647,103648,104284,105131)
update T_AR_RECEIVEBILLENTRY set FWRITTENOFFAMOUNTFOR=FRECTOTALAMOUNTFOR
WHERE FPURPOSEID IN (SELECT fid FROM T_CN_RECPAYPURPOSE WHERE FFINMANEGEMENT = '1')and fid in(103647,103648,104284,105131)
update T_AR_RECEIVEBILLENTRY set FWRITTENOFFAMOUNTFOR=FRECTOTALAMOUNTFOR
WHERE FPURPOSEID IN (SELECT fid FROM T_CN_RECPAYPURPOSE WHERE FFINMANEGEMENT = '1')and fid in(103647,103648,104284,105131)
本文转自51GT51CTO博客，原文链接： http://blog.51cto.com/yataigp/2043645，如需转载请自行联系原作者
