USP_RE7TRIBUTESEARCH

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

      if @DESCRIPTION is not null
        set @DESCRIPTION = '%' + isnull(@DESCRIPTION, '') + '%';

      select  top (@MAXROWS)
      [T].[LOCALID] [ID],
      [T].[DESCRIPTION],
      [C].[FULLNAME],
      [TTC].[DESCRIPTION] [TRIBUTETYPE],
      case when isnull([T].[DESCRIPTION], '') = '' then [C].[FULLNAME] + ' - ' + [TTC].[DESCRIPTION] else [C].[FULLNAME] + ' - ' + [TTC].[DESCRIPTION] + ' - ' + [T].[DESCRIPTION] end [IDENTIFIER]
      from [dbo].[RE7_TRIBUTE] [T]
      left outer join [dbo].[RE7_CONSTITUENT] [C] on [T].[CONSTITUENT_LOCALID] = [C].[LOCALID]
      left outer join dbo.[RE7_TRIBUTETYPECODE] [TTC] on [T].[TYPECODE_LOCALID] = [TTC].[LOCALID]
      where
      (@DESCRIPTION is null or ([T].[DESCRIPTION] like @DESCRIPTION))
      and
      (@SYSTEMRECORDID is null or ([T].[LOCALID] = @SYSTEMRECORDID));

      return 0;