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 ( 'PLRD00000200055', -- REQ_ID - varchar(15) 'PTGD_DC', -- PROCESS_ID - varchar(10) 'C', -- STATUS - varchar(5) 'PTGD', -- ROLE_USER - varchar(50) '', -- BRANCH_ID - varchar(15) '', -- CHECKER_ID - varchar(15) NULL, -- APPROVE_DT - datetime 'TC', -- PARENT_PROCESS_ID - varchar(10) '', -- IS_LEAF - varchar(1) '', -- COST_ID - varchar(15) 'DM0000000000017', -- DVDM_ID - varchar(15) N'', -- NOTES - nvarchar(500) NULL, -- IS_HAS_CHILD - bit '' -- DEP_ID - varchar(20) ) UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='PTGD_DC' WHERE REQ_ID='PLRD00000200055' UPDATE dbo.TR_REQUEST_DOC_DT SET SUP_ID='CMS000000251234',HANGHOA_ID='HH0000000112222' WHERE REQ_DOC_ID IN ('TRRDII001055328','TRRDII001055329')