Shulou(Shulou.com)06/01 Report--

-- check whether the carry-over quantity is incorrect.

Select shqjzhshl,cwjcsl+cksl-bqrsh,bqrsh-cksl, from ymjzhk where spid='SPH00000562' order by jzhh desc

-- check whether the carry-over data of the carry-over database and the flow reservoir are consistent.

Select jzhh,sum (rkshl), sum (chkshl), sum (rkshl)-sum (chkshl) From splsk where spid='SPH00000562' group by jzhh order by jzhh desc

-- by comparison, it is found that the JZH00000040 carry-over library cksl is 90% more.

-- backup needs to update data

Select into fr_ymjzhk20190102_SPH00000562 from ymjzhk where spid='SPH00000562' and nian='2018' order by jzhh desc

-- updating data

Update ymjzhk set cksl=1616-90 where spid='SPH00000562' and jzhh='JZH00000040' bqxsshlforth 1616-90 repertoire bqyshang bqyshang 90 minus cwjcslant

Update ymjzhk set shqjzhshl=shqjzhshl+90,bqysh=bqysh+90,cwjcsl=cwjcsl+90 where spid='SPH00000562' and jzhh='JZH00000041'

Update ymjzhk set shqjzhshl=shqjzhshl+90,bqysh=bqysh+90,cwjcsl=cwjcsl+90 where spid='SPH00000562' and jzhh='JZH00000042'

Update ymjzhk set shqjzhshl=shqjzhshl+90,bqysh=bqysh+90,cwjcsl=cwjcsl+90 where spid='SPH00000562' and jzhh='JZH00000043'

Update ymjzhk set shqjzhshl=shqjzhshl+90,bqysh=bqysh+90,cwjcsl=cwjcsl+90 where spid='SPH00000562' and jzhh='JZH00000044'

Update ymjzhk set shqjzhshl=shqjzhshl+90,bqysh=bqysh+90,cwjcsl=cwjcsl+90 where spid='SPH00000562' and jzhh='JZH00000045'

Update ymjzhk set shqjzhshl=shqjzhshl+90,bqysh=bqysh+90,cwjcsl=cwjcsl+90 where spid='SPH00000562' and jzhh='JZH00000046'

Update ymjzhk set shqjzhshl=shqjzhshl+90,bqysh=bqysh+90,cwjcsl=cwjcsl+90 where spid='SPH00000562' and jzhh='JZH00000047'

-- update the carry-over quantity (easy to forget)

Update spkfjc set shqjzhshl=230+90 where spid='SPH00000562'

Update hwsp set jzshl=230+90 where spid='SPH00000562' and hw='HWI00000025'

-- check that all carryover quantities are correct

Select * from spkfjc where cwsqjzslkcshl

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.