USP_SEARCHLIST_FAFEVENT

Search for event records.

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

SELECT TOP (@MAXROWS) 
      EVENT.ID, 
      EVENT.NAME, 
      EVENT.STARTDATE, 
      EVENT.ENDDATE

FROM dbo.EVENT (NOLOCK)
where
EVENT.ISACTIVE = 1 
and PROGRAMID IS NULL
and (EVENT.NAME LIKE @NAME)
 ORDER BY NAME asc