USP_RE7BBNCPERSONALPAGESEARCH

      create procedure dbo.USP_RE7BBNCPERSONALPAGESEARCH
      (
      @DESCRIPTION nvarchar(100) = null,
      @SYSTEMRECORDID int = null,
      @MAXROWS smallint = 0
      )
      as
      set nocount on;

      if @DESCRIPTION is not null
        set @DESCRIPTION = '%' + @DESCRIPTION + '%';

      with [RANKEDPAGES] ([PAGE_LOCALID], [NAME], [SEQUENCE]) as
      (
        select 
          [PAGE_LOCALID], 
          [NAME], 
          row_number() over(partition by [PAGE_LOCALID] order by [DATELASTVISIT] desc)
        from
          dbo.[RE7_BBNCPERSONALPAGES] where [PAGE_LOCALID] > 0 and [NAME] is not null
      )
      select top (@MAXROWS)
        [PAGE_LOCALID] [ID], 
        [NAME] [DESCRIPTION]
      from [RANKEDPAGES] 
      where 
      [SEQUENCE] = 1 
      and
      (@DESCRIPTION is null or ([NAME] like @DESCRIPTION))
      and
      (@SYSTEMRECORDID is null or ([PAGE_LOCALID] = @SYSTEMRECORDID))
      order by [NAME];

      return 0;