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