USP_SEARCHLIST_FINANCIALBATCH

Searches for a financial batch

Parameters

Parameter	Parameter Type	Mode	Description
@NUMBER	nvarchar(100)	IN	Number
@COMMENT	nvarchar(100)	IN	Comment
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_FINANCIALBATCH
(
    @NUMBER nvarchar(100) = null
  ,@COMMENT nvarchar(100) = null
    ,@MAXROWS smallint = 500
)
as
    set @NUMBER = COALESCE(@NUMBER,'') + '%' ;
  set @COMMENT = COALESCE(@NUMBER,'') + '%';

    select top(@MAXROWS)
        ID
        ,cast(NUMBER as nvarchar(100)) as NUMBER
    ,COMMENT
    ,DATEADDED
    from 
        dbo.FINANCIALBATCH
    where
         (cast(NUMBER as nvarchar(100)) LIKE @NUMBER)
     AND (COMMENT LIKE @COMMENT)
    order by 
        NUMBER asc