USP_SEARCHLIST_FEE

Search for a system fee.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_SEARCHLIST_FEE
            (
                @NAME nvarchar(100) = null,
                @MAXROWS smallint = 500
            )
            as
                set @NAME = COALESCE(@NAME,'') + '%' ;

                select top(@MAXROWS)
                    ID,
                    NAME,
                    TYPE,
                    APPLIESTO
                from 
                    dbo.FEE
                where
                     (NAME LIKE @NAME)
                order by 
                    NAME asc