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

declare @req_pay_id varchar(15), @ref_id varchar(15)

DECLARE cursorProduct CURSOR FOR

SELECT REQ_PAY_ID,REF_ID FROM TR_REQ_ADVANCE_PAYMENT A WHERE A.REQ_TYPE ='I'

Open cursorProduct

FETCH NEXT FROM cursorProduct INTO @req_pay_id, @ref_id

WHILE @@FETCH_STATUS = 0

BEGIN

   UPDATE TR_REQ_ADVANCE_PAYMENT SET RECEIVER_DEBIT =(SELECT ISNULL(ACC_NUM,'') FROM CM_ACCOUNT_PAY WHERE REF_ID =@ref_id AND ACC_TYPE ='ADV_PAY' ) WHERE REQ_PAY_ID =@req_pay_id

FETCH NEXT FROM cursorProduct INTO  @req_pay_id, @ref_id

END