USP_DECODEURL

CREATE procedure USP_DECODEURL
as 
  begin 
  declare @RecordUpdateCount int =0;
   declare @PATTERN char(21)     
    set @PATTERN = '%[%][0-9a-f][0-9a-f]%';

    update top (100) dbo.STATS 
    set    URL=[dbo].[UFN_DECODEURL](URL)
    where    len(isnull(url,'')) >0
                  and    SOURCEID>0 
                  and    patindex(@PATTERN, URL ) >0;

set @RecordUpdateCount =@RecordUpdateCount + isnull(@@ROWCOUNT,0);

    update top (100) dbo.EMAILLINK                                                                                                        
    set    URL=[dbo].[UFN_DECODEURL](URL) 
    where    len(isnull(url,'')) >0                  
             and    PATINDEX( @PATTERN, URL ) > 0;


set @RecordUpdateCount =@RecordUpdateCount + isnull(@@ROWCOUNT,0);

select  @RecordUpdateCount;
end