DECLARE @REQ_DOC_ID VARCHAR(15) DECLARE CURS_NCC CURSOR LOCAL FOR SELECT REQ_ID FROM TR_REQUEST_DOC OPEN CURS_NCC FETCH NEXT FROM CURS_NCC INTO @REQ_DOC_ID WHILE @@FETCH_STATUS = 0 BEGIN DECLARE @p_KeyGen varchar(15) -- GOI STORE IMPORT DU LIEU --EXEC SYS_CodeMasters_Gen 'LS_CUSTOMER', @p_KeyGen out --IF @p_KeyGen='' OR @p_KeyGen IS NULL GOTO ABORT-- Insert UPDATE TR_REQUEST_DOC SET TOTAL_AMT =(SELECT SUM(TOTAL_AMT) FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_DOC_ID) WHERE REQ_ID =@REQ_DOC_ID FETCH NEXT FROM CURS_NCC INTO @REQ_DOC_ID END CLOSE CURS_NCC DEALLOCATE CURS_NCC