USP_RE7CAMPAIGNSEARCH

      create procedure dbo.USP_RE7CAMPAIGNSEARCH
      (
      @DESCRIPTION nvarchar(255) = null,
      @IDENTIFIER nvarchar(20) = null,
      @CATEGORY int = null,
      @SYSTEMRECORDID int = null,
      @MAXROWS smallint = 0
      )
      as
      set nocount on;

      set @DESCRIPTION = '%' + isnull(@DESCRIPTION, '') + '%';
      set @IDENTIFIER = '%' + isnull(@IDENTIFIER, '') + '%';

      select top (@MAXROWS)
      [C].[LOCALID] [ID],
      [C].[NAME] [IDENTIFIER],
      [C].[DESCRIPTION],
      [CC].[DESCRIPTION] [CATEGORY]
      from [dbo].[RE7_CAMPAIGN] [C]
      left outer join dbo.[RE7_CAMPAIGNCATEGORYCODE] [CC] on [C].[CAMPAIGNCATEGORYCODE_LOCALID] = [CC].[LOCALID]
      where
      (@DESCRIPTION is null or ([C].[DESCRIPTION] like @DESCRIPTION))
      and
      (@IDENTIFIER is null or ([C].[NAME] like @IDENTIFIER))
      and
      (@CATEGORY is null or ([C].[CAMPAIGNCATEGORYCODE_LOCALID] = @CATEGORY))
      and
      (@SYSTEMRECORDID is null or ([C].[LOCALID] = @SYSTEMRECORDID));

      return 0;