Advertisement
Guest User

Untitled

a guest
Nov 21st, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. update t0 set t0.series=t2.series
  2. from NNM2 t0
  3. inner join NNM1 t1 on t1.Series=t0.Series
  4. inner join NNM1 t2 on t2.SeriesName=replace(t1.SeriesName,'19','20') and t1.ObjectCode=t2.objectcode
  5. --and t0.ObjectCode='13'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement