UPDATE dbo.PL_REQUEST_DOC_DT SET DVDM_ID='DM0000000000003',KHOI_ID='DM0000000000015' WHERE REQ_ID='PLRD00000200146' INSERT INTO dbo.PL_REQUEST_PROCESS ( REQ_ID, PROCESS_ID, STATUS, ROLE_USER, BRANCH_ID, CHECKER_ID, APPROVE_DT, PARENT_PROCESS_ID, IS_LEAF, COST_ID, DVDM_ID, NOTES, IS_HAS_CHILD, DEP_ID ) VALUES ( 'PLRD00000200146', -- REQ_ID - varchar(15) 'GDK_TT', -- PROCESS_ID - varchar(10) 'C', -- STATUS - varchar(5) 'GDK', -- ROLE_USER - varchar(50) '', -- BRANCH_ID - varchar(15) '', -- CHECKER_ID - varchar(15) NULL, -- APPROVE_DT - datetime 'KT', -- PARENT_PROCESS_ID - varchar(10) '', -- IS_LEAF - varchar(1) '', -- COST_ID - varchar(15) 'DM0000000000015', -- DVDM_ID - varchar(15) N'', -- NOTES - nvarchar(500) NULL, -- IS_HAS_CHILD - bit '' -- DEP_ID - varchar(20) ) UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='U',PARENT_PROCESS_ID='GDK_TT' WHERE PROCESS_ID='APPROVE' AND REQ_ID='PLRD00000200146' UPDATE dbo.PL_REQUEST_PROCESS SET PROCESS_ID='GDK_TT' WHERE REQ_ID='PLRD00000200146' UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-59796000 WHERE TRADE_ID='PLT000000074374'