Text 
CREATE PROCEDURE [dbo].[PAY_ENTRIES_POST_UpdRef]  
@p_ET_ID varchar(50) = NULL,  
@p_PAIR_ID varchar(50) = NULL,  
@p_REF_NO VARCHAR(100) = ''---SO REF NO CUA CORE TRA VE  
AS  
BEGIN TRY  
DECLARE @REQ_ID VARCHAR(15)  
SET @REQ_ID =(SELECT TOP 1 TRN_ID FROM PAY_ENTRIES_POST WHERE ET_ID =@p_ET_ID)  
UPDATE PAY_ENTRIES_POST  
SET REF_NO = @p_REF_NO  
--WHERE ET_ID = @p_ET_ID AND ENTRY_PAIR = @p_PAIR_ID  
WHERE ENTRY_PAIR = @p_PAIR_ID AND TRN_ID =@REQ_ID  
SELECT '0' RESULT, '' ERROR  
RETURN 0  
END TRY  
BEGIN CATCH  
SELECT '-1' RESULT, ERROR_MESSAGE() ERROR  
RETURN -1  
END CATCH