Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Adrian, May 16, 2018
- --Insert sl_so_ext untuk so yang dibuat sebelum ada table sl_so_ext
- INSERT INTO sl_so_ext(
- so_id, tenant_id, flg_manual_consignment, version, create_datetime,
- create_user_id, update_datetime, update_user_id)
- SELECT A.so_id, A.tenant_id, 'N', 0, '20180608010101',
- -1, '20180608010101', -1
- FROM sl_so A
- WHERE NOT EXISTS(
- SELECT 1
- FROM sl_so_ext Z
- WHERE Z.so_id = A.so_id
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement