安宫牛黄结转周期错误JZH00000028update spls_ck set jzhh='JZH00000027' where djbh='XSAYMA00137462' update wlzhk set jzhh='JZH00000027' where wlzhk where plh='Z0001407138'
I900003 碧生源牌常润茶sphwph数量1月20日不明原因 数量多了6007 现在初步调整,批号核对完调整相应批号update sphwph set shl=5947-5947 where spid='SPH00000553' and pici='JHAYMA00018523_22' and hw='HWI00000002'update sphwph set shl=51-60 w
对保险汇总数据的删除与修正补充select * into fr_jh_rkhz20170210 from jh_rkhz where djbh in (select djbh from fr_spls_rk20170123)select * into fr_cwk20170210 from cwk where djbh in (select djbh from fr_spls_rk20170123
结转前因结转不涉及余额未对wlzhk余额处理select * into fr_wlzhk20170123 from wlzhk where left(dwbh,3)<>'DWI'update wlzhk set dwbh=replace(dwbh,'CWI','DWI') where left(dwbh,3)<>'DWI'update wlzhk set dwbh
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号