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 ( '', -- REQ_ID - varchar(15) 'DMMS', -- PROCESS_ID - varchar(10) 'P', -- STATUS - varchar(5) 'GDDV', -- ROLE_USER - varchar(50) '', -- BRANCH_ID - varchar(15) '', -- CHECKER_ID - varchar(15) GETDATE(), -- APPROVE_DT - datetime '', -- PARENT_PROCESS_ID - varchar(10) '', -- IS_LEAF - varchar(1) '', -- COST_ID - varchar(15) '', -- DVDM_ID - varchar(15) N'', -- NOTES - nvarchar(500) 1, -- IS_HAS_CHILD - bit '' -- DEP_ID - varchar(20) ) INSERT INTO dbo.PL_REQUEST_PROCESS_CHILD ( REQ_ID, PROCESS_ID, TLNAME, TYPE_JOB, LEVEL_JOB, STATUS_JOB, RECORD_STATUS, MAKER_ID, TRANFER_DT ) VALUES ( '', -- REQ_ID - varchar(20) '', -- PROCESS_ID - varchar(20) '', -- TLNAME - varchar(50) '', -- TYPE_JOB - varchar(50) 0, -- LEVEL_JOB - int '', -- STATUS_JOB - varchar(10) '', -- RECORD_STATUS - varchar(15) '', -- MAKER_ID - varchar(15) GETDATE() -- TRANFER_DT - datetime )