DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

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