ALTER   PROCEDURE [dbo].[PAY_ENTRIES_POST_UpdRef]  
@p_ET_ID varchar(MAX) = NULL,  
@p_ENTRY_PAIR varchar(50) = NULL, 
@p_TRN_ID varchar(50) = NULL, 
@p_REF_NO VARCHAR(100) = ''---SO REF NO CUA CORE TRA VE  
AS  
BEGIN TRY  
UPDATE PAY_ENTRIES_POST  
SET REF_NO = @p_REF_NO , 
TRN_DATE = GETDATE() -- LUCTV 28042021: BO SUNG NEU TRUONG HOP RETRY BUT TOAN THI NGAY HACH TOAN TREN AMS VA NGAY HACH TOAN TREN CORE FC PHAI KHOP NHAU
WHERE ET_ID IN (SELECT * FROM wsiSplit(@p_ET_ID,','))
/*
-- doanptt update ref_no danh sách chuyển tiền ngoài hệ thống
UPDATE TR_REQ_PAY_TRANS_OUTSIDE_REC
SET REF_NO = @p_REF_NO
WHERE REQ_PAY_ID = @p_TRN_ID AND ENTRY_PAIR = @p_ENTRY_PAIR
*/
--SELECT * FROM wsiSplit('PET000000000016,PET000000000017,PET000000000018,PET000000000019',',')

SELECT '0' RESULT, '' ERROR  
RETURN 0  
END TRY  
BEGIN CATCH  
SELECT '-1' RESULT, ERROR_MESSAGE() ERROR  
RETURN -1  
END CATCH