USP_RE7FUNDSEARCH

Parameters

Parameter	Parameter Type	Mode
@DESCRIPTION	nvarchar(255)	IN
@IDENTIFIER	nvarchar(20)	IN
@CATEGORY	int	IN
@SYSTEMRECORDID	int	IN
@MAXROWS	smallint	IN

Definition

Copy



      create procedure dbo.USP_RE7FUNDSEARCH
      (
      @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)
      [F].[LOCALID] [ID],
      [F].[NAME] [IDENTIFIER],
      [F].[DESCRIPTION],
      [FC].[DESCRIPTION] [CATEGORY]
      from [dbo].[RE7_FUND] [F]
      left outer join dbo.[RE7_FUNDCATEGORYCODE] [FC] on [F].[FUNDCATEGORYCODE_LOCALID] = [FC].[LOCALID]
      where
      (@DESCRIPTION is null or ([F].[DESCRIPTION] like @DESCRIPTION))
      and
      (@IDENTIFIER is null or ([F].[NAME] like @IDENTIFIER))
      and
      (@CATEGORY is null or ([F].[FUNDCATEGORYCODE_LOCALID] = @CATEGORY))
      and
      (@SYSTEMRECORDID is null or ([F].[LOCALID] = @SYSTEMRECORDID));

      return 0;