Advertisement
aadddrr

Init sl_so_ext

Jun 8th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --Adrian, May 16, 2018
  2.     --Insert sl_so_ext untuk so yang dibuat sebelum ada table sl_so_ext
  3.  
  4.     INSERT INTO sl_so_ext(
  5.             so_id, tenant_id, flg_manual_consignment, version, create_datetime,
  6.             create_user_id, update_datetime, update_user_id)
  7.     SELECT A.so_id, A.tenant_id, 'N', 0, '20180608010101',
  8.                 -1, '20180608010101', -1
  9.     FROM sl_so A
  10.     WHERE NOT EXISTS(
  11.         SELECT 1
  12.         FROM sl_so_ext Z
  13.         WHERE Z.so_id = A.so_id
  14.     );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement