DECLARE @SP VARCHAR(15), @DATE_TAO DATE, @DATE_DUYET DATE
DECLARE CURR CURSOR local
FOR SELECT A.SO_PHIEU, A.NGAY_TAO, A.NGAY_DUYET FROM TAM_UNG_NOI_BO A
open CURR
FETCH NEXT FROM CURR INTO @SP , @DATE_TAO , @DATE_DUYET 
WHILE @@FETCH_STATUS = 0     
BEGIN
	UPDATE TR_REQ_ADVANCE_PAYMENT SET REQ_DT =@DATE_TAO, APPROVE_DT =@DATE_DUYET, CREATE_DT =@DATE_TAO
	where REQ_PAY_CODE =@SP
	FETCH NEXT FROM CURR INTO @SP , @DATE_TAO , @DATE_DUYET 
END
CLOSE CURR
DEALLOCATE CURR