USP_SEARCHLIST_ACTIONITEM_2

This provides quick search for Action Items in advocacy reports

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_SEARCHLIST_ACTIONITEM_2
                (
                    @NAME nvarchar(250) = NULL,
          @MAXROWS smallint = 500
                ) with execute as owner
                as
                    SET @NAME = '%' + @NAME + '%' ;

          select AI.ID,
                 AI.NAME,
                 AI.TYPE,
                 AI.STATUS,
                 AI.TOPIC
                        from 
                            dbo.ACTION_ITEM AI (NOLOCK)
                        where
                             AI.NAME LIKE ISNULL(@NAME,AI.NAME)