ALTER PROCEDURE [dbo].[MW_ENTRIES_POST_UpdRef]
	@p_ET_ID varchar(MAX) = NULL,
	@p_REF_NO VARCHAR(50) = ''---SO REF NO CUA CORE TRA VE
AS
BEGIN TRY
	UPDATE MW_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,','))
	
	SELECT '0' RESULT, '' ERROR
	RETURN 0
END TRY
BEGIN CATCH
	SELECT '-1' RESULT, ERROR_MESSAGE() ERROR
RETURN -1
END CATCH
¿
ALTER PROCEDURE [dbo].[PAY_ENTRIES_POST_UpdRef]  
@p_ET_ID varchar(500) = NULL,  
@p_PAIR_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,','))

--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  
¿
DECLARE @MENUID INT
SET @MENUID =(SELECT TOP 1 MENU_ID FROM TL_MENU WHERE  MENU_LINK ='/PlanManager/TransferJobList')
--SELECT * FROM TL_SYSROLEDETAIL WHERE ROLE_ID ='GDK' AND MENU_ID ='9250'
UPDATE  TL_SYSROLEDETAIL SET ISUPDATE =1, ISEDIT =1 WHERE ROLE_ID ='GDK' AND MENU_ID ='9250'
UPDATE  TL_SYSROLEDETAIL SET ISUPDATE =1, ISEDIT =1 WHERE ROLE_ID ='GDK' AND MENU_ID =@MENUID

DELETE FROM PL_PROCESS WHERE CHECKER_ID ='cuongpv2' AND REQ_ID ='PLRD00000201194'