關于時空結轉的一些說明

由于上次對資料進行清空，而另一些表進行相關的運算導緻結轉錯誤

過程參考ymjz_proc

具體涉及到的表

hwsp的更新

spkfjc的更新 

以上兩表的必須正确否則下次結轉還要出錯

以上兩表主要是單價是成本單價

ymjzhk的更新

update b set shqjzhshl=a.bqysh,shqjzhje=a.bqye,shqjzdj=a.jcdj 

from ymjzhk b,fr_ymjzhk20150130 a  where b.jzhh='JZH00000001' and a.spid=b.spid and a.jzhh='JZH00000000'

update b set bqysh=a.shqjzhshl,bqye=a.shqjzhje,jcdj=a.shqjzhdj 

from ymjzhk b,spkfjc a  where b.jzhh='JZH00000001' and a.spid=b.spid 

ymhwjzhz的更新不列出了比較簡單

ymhwjzmx表的更新

from ymhwjzmx b,fr_ymhwjzmx20150130 a  where b.jzhh='JZH00000001' and a.spid=b.spid and a.jzhh='JZH00000000' and a.hw=b.hw

update b set bqysh=a.jzshl,bqye=a.jzje,jcdj=a.jzdj 

from ymhwjzmx b,hwsp a  where b.jzhh='JZH00000001' and a.spid=b.spid and a.hw=b.hw

本文轉自 qvodnet 51CTO部落格，原文連結:http://blog.51cto.com/bks2015/1610090