USP_SEARCHLIST_GLACCOUNT2

This provides the ability to search for an account.

Parameters

Parameter	Parameter Type	Mode	Description
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	PDACCOUNTSYSTEMID
@ACCOUNTNUMBER	nvarchar(100)	IN	Account number
@ACCOUNTDESCRIPTION	nvarchar(100)	IN	Description
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



                CREATE procedure dbo.USP_SEARCHLIST_GLACCOUNT2
                (
                    @PDACCOUNTSYSTEMID uniqueidentifier,
                    @ACCOUNTNUMBER nvarchar(100) = null,
                    @ACCOUNTDESCRIPTION nvarchar(100) = null,
                    @MAXROWS smallint = 500
                )
                as
                    set nocount on;

                    select top(@MAXROWS)
                        ID,
                        ACCOUNTNUMBER,
                        ACCOUNTDESCRIPTION
                    from
                        dbo.GLACCOUNT
                    where
                    PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and
                        ((@ACCOUNTNUMBER is null)
                        or (ACCOUNTNUMBER like REPLACE(REPLACE(@ACCOUNTNUMBER, '*', '%'), '?', '_') + '%'))
            and ((@ACCOUNTDESCRIPTION is null)
            or (ACCOUNTDESCRIPTION like REPLACE(REPLACE(@ACCOUNTDESCRIPTION, '*', '%'), '?', '_') + '%'))
                    order by
                        ACCOUNTNUMBER

                    return 0;