USP_SEARCHLIST_DISBURSEMENTREPORT

Search screen for finding disbursement reports.

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

    select top(@MAXROWS)
        R.ID, 
        R.NAME,
        R.DESCRIPTION
        from REPORTCATALOG R
        where 
      R.REPORTSPECXML.value('(/)[1]', 'nvarchar(max)') like '%Check Reports%'
      and not (R.REPORTSPECXML.value('(/)[1]', 'nvarchar(max)') like '%Check Reports/Check Subreports%')
        and NAME like @NAME
        order by 
        NAME asc