USP_SEARCHLIST_SIMPLEDATALIST

Search for a simple data list.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_SIMPLEDATALIST
(
    @MAXROWS smallint = 500,
    @NAME nvarchar(100) = null
)
as
    set nocount on;

    set @NAME = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@NAME, 0, null);

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