USP_SEARCHLIST_ASSIGNMENT

This provides the ability to search for an assignment.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(20)	IN	Assignment 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_ASSIGNMENT
            (
                @NAME nvarchar(20) = null,
                @DESCRIPTION nvarchar(255) = null,
                @MAXROWS smallint = 500
            )
            as
                set nocount on;

                select top(@MAXROWS) 
                       dbo.ASSIGNMENT.ID,
                       dbo.ASSIGNMENT.NAME,
                       dbo.ASSIGNMENT.DESCRIPTION
                from dbo.ASSIGNMENT
                where 
                    (@NAME is null or (dbo.ASSIGNMENT.NAME like @NAME + '%')) and
                    (@DESCRIPTION is null or (dbo.ASSIGNMENT.DESCRIPTION like @DESCRIPTION + '%'))