update jxddhz set dwbh='DWI00000053' where djbh='JHFYMA00030945 '
update jxddmx set dj_sn=16 where djbh='JHFYMA00030945 ' and dj_sn=15
insert into jxddmx
select a.cgddh,a.cgdd_sort,a.spid,4 as dj_sort,'否','',0,'',0,b.dw,'',b.jlgg,a.jiansh,a.lingsshl,a.shl,15/1.17 as dj,15 as hshj,100,a.shl*15/1.17 as je,b.shlv,a.shl*15-a.shl*15/1.17 as she,a.shl*15 as hsje,0,0,0,'','','否',3,0,'',14.71 pckhdj,'' xsbmxz,14.71 pcxsxj
from INT_WMS_CGRK_BILL a,spkfk b
where a.spid=b.spid and a.djbh='RKD00003299'
本文转自 qvodnet 51CTO博客，原文链接:http://blog.51cto.com/bks2015/1940652
