USP_SEARCHLIST_ACTIVEDAILYADMISSIONPROGRAM

Search for an active daily admission program.

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_ACTIVEDAILYADMISSIONPROGRAM
            (
                @NAME nvarchar(100) = null,
                @MAXROWS smallint = 500
            )
            as
                set @NAME = COALESCE(@NAME,'') + '%' ;

                select top(@MAXROWS)
                    ID,
                    NAME
                from dbo.PROGRAM
                where ISDAILYADMISSION = 1
                and ISACTIVE = 1
                order by NAME asc