USP_SEARCHLIST_CURRENCY

Used to search for currencies.

Parameters

Parameter	Parameter Type	Mode	Description
@ISO4217	nvarchar(3)	IN	ISO code
@NAME	nvarchar(255)	IN	Name
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.
@EXACTMATCHONLY	bit	IN	Exact match only

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_CURRENCY
(
    @ISO4217 nvarchar(3) = null,
    @NAME nvarchar(255) = null,
    @MAXROWS smallint = 500,
    @EXACTMATCHONLY bit = 0
)
as
    set nocount on;                

    if @EXACTMATCHONLY = 1
        select top(@MAXROWS)
            CURRENCY.ID,
            CURRENCY.ISO4217,
            CURRENCY.NAME
        from
            dbo.CURRENCY
        where
            CURRENCY.ISO4217 = COALESCE(@ISO4217,'')
        order by
            CURRENCY.ISO4217,
            CURRENCY.NAME;
    else
        begin
            set @ISO4217 = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@ISO4217, 0, null);
            set @NAME = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@NAME, 0, null);

            select top(@MAXROWS)
                CURRENCY.ID,
                CURRENCY.ISO4217,
                CURRENCY.NAME
            from
                dbo.CURRENCY
            where
                ((@NAME is null) or (CURRENCY.NAME like @NAME)) and 
                ((@ISO4217 is null) or (CURRENCY.ISO4217 like @ISO4217)) and 
                (CURRENCY.INACTIVE = 0)
            order by
                CURRENCY.ISO4217,
                CURRENCY.NAME;
        end