USP_RE7REVENUESEARCH

      create procedure dbo.USP_RE7REVENUESEARCH
      (
      @LASTNAME nvarchar(100) = null,
      @FIRSTNAME nvarchar(50) = null,
      @LOOKUPID nvarchar(100) = null,
      @TYPE int = null,
      @FINDERNUMBER numeric(19,0) = null,
      @SYSTEMRECORDID int = null,
      @MAXROWS smallint = 0
      )
      as
      set nocount on;

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

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

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

      if @FINDERNUMBER = 0
        set @FINDERNUMBER = null;

      select  top (@MAXROWS)
      [RS].[LOCALID] [ID],
      [C].[FULLNAME] + ' - ' + [TC].[DESCRIPTION] + ' - ' + [F].[DESCRIPTION] [DESCRIPTION],
      [C].[FULLNAME],
      [R].[DATE],
      [TC].[DESCRIPTION] [REVENUETYPE],
      [RS].[AMOUNT],
      [F].[DESCRIPTION] [FUND]
      from dbo.[RE7_REVENUESPLIT] [RS]
      left outer join dbo.[RE7_REVENUE] [R] on [RS].[REVENUE_LOCALID] = [R].[LOCALID]
      left outer join dbo.[RE7_CONSTITUENT] [C] on [R].[CONSTITUENT_LOCALID] = [C].[LOCALID]
      left outer join dbo.[RE7_REVENUETYPECODE] [TC] on [R].[TYPECODE_LOCALID] = [TC].[LOCALID]
      left outer join dbo.[RE7_FUND] [F] on [RS].[FUND_LOCALID] = [F].[LOCALID]
      where
      (@LASTNAME is null or ([C].[KEYNAME] like @LASTNAME))
      and
      (@FIRSTNAME is null or ([C].[FIRSTNAME] like @FIRSTNAME))
      and
      (@LOOKUPID is null or ([C].[LOOKUPID] like @LOOKUPID))
      and
      (@TYPE is null or ([R].[TYPECODE_LOCALID] = @TYPE))
      and
      (@FINDERNUMBER is null or ([R].[FINDERNUMBER] = @FINDERNUMBER))
      and
      (@SYSTEMRECORDID is null or ([R].[LOCALID] = @SYSTEMRECORDID));

      return 0;