CREATE PROCEDURE [dbo].[ASS_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 ASS_ENTRIES_POST SET REF_NO = @p_REF_NO 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