USP_SEARCHLIST_ACCOUNTINGELEMENTSECURITYGROUP

This provides the ability to search for accounting element security groups.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_ACCOUNTINGELEMENTSECURITYGROUP
(
    @NAME nvarchar(100) = null,
  @DESCRIPTION nvarchar(255) = null,
    @MAXROWS smallint = 500
)
as
    set @NAME = COALESCE(@NAME,'') + '%' ;
  set @DESCRIPTION = coalesce(replace(@DESCRIPTION,'*','%'),'') + '%';

    select top(@MAXROWS)
        ID,
        NAME,
        DESCRIPTION
    from 
        dbo.ACCOUNTINGELEMENTSECURITYGROUP
    where
         ((NAME like @NAME) or (@NAME is null)) and (DESCRIPTION like @DESCRIPTION or @DESCRIPTION is null) 
    order by 
        NAME asc