USP_RE7EVENTSEARCH

      create procedure dbo.USP_RE7EVENTSEARCH
      (
      @DESCRIPTION nvarchar(50) = null,
      @IDENTIFIER nvarchar(50) = null,
      @CATEGORY int = null,
      @GROUP int = null,
      @TYPE int = null,
      @LOCATION nvarchar(60) = null,
      @SYSTEMRECORDID int = null,
      @MAXROWS smallint = 0
      )
      as
      set nocount on;

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

  select top (@MAXROWS)
  [E].[LOCALID] [ID],
  [E].[IDENTIFIER],
  [E].[NAME] [DESCRIPTION],
  [ECC].[DESCRIPTION] [CATEGORY],
  [EGC].[DESCRIPTION] [GROUP],
  [ETC].[DESCRIPTION] [TYPE],
  [E].[LOCATIONNAME]
from [dbo].[RE7_EVENTS] [E]
left outer join dbo.[RE7_EVENTCATEGORYCODE] [ECC] on [E].[CATEGORYCODE_LOCALID] = [ECC].[LOCALID]
left outer join dbo.[RE7_EVENTGROUPCODE] [EGC] on [E].[GROUPCODE_LOCALID] = [EGC].[LOCALID]
left outer join dbo.[RE7_EVENTTYPECODE] [ETC] on [E].[TYPECODE_LOCALID] = [ETC].[LOCALID]
where
      (@DESCRIPTION is null or (isnull([E].[NAME], '') like @DESCRIPTION))
      and
      (@IDENTIFIER is null or (isnull([E].[IDENTIFIER], '') like @IDENTIFIER))
      and
      (@CATEGORY is null or ([E].[CATEGORYCODE_LOCALID] = @CATEGORY))
      and
      (@GROUP is null or ([E].[GROUPCODE_LOCALID] = @GROUP))
      and
      (@TYPE is null or ([E].[TYPECODE_LOCALID] = @TYPE))
      and
      (@LOCATION is null or (isnull([E].[LOCATIONNAME], '') like @LOCATION))
      and
      (@SYSTEMRECORDID is null or ([E].[LOCALID] = @SYSTEMRECORDID));
      return 0;