insert into Department
select
     'B300'
    ,date('2023-04-01')
    ,null
    ,'新設部門'
    ,Layer
    ,Up_Dept_Code
    ,'1'
    ,update_user_name
    ,datetime('2023-04-01 00:00:00')
from 
    department
where
    dept_Code = 'A100'
;

update
    department
set 
     end_date = date('2023-03-31')
    ,valid_flg = '0'
    ,update_user_name = 'ORG_CHG'
    ,user_update_datetime = datetime('2023-03-31 23:59:59')
where
    dept_code in ('A100', 'A200')
;

update
    emp
set
     dept_code ='B300'
    ,start_date = date('2023-04-01')
    ,update_user_name = 'ORG_CHG'
    ,user_update_datetime = '2023-04-01 00:00:00'
where
    valid_flg = '1'
and
    dept_code in ('A100', 'A200')
;