USP_CURRENCY_DATALIST

CREATE procedure dbo.USP_CURRENCY_DATALIST
(
    @INCLUDEINACTIVE bit = 1
)
as
    set nocount on;

        select
            CURRENCY.ID,
            CURRENCY.NAME,
            CURRENCY.ISO4217,
            LOCALE.NAME LOCALE,
            CURRENCY.DECIMALDIGITS,
            CURRENCY.CURRENCYSYMBOL,
            CURRENCY.ROUNDINGTYPE,
            ~CURRENCY.INACTIVE as ACTIVE,
            CURRENCY.ISORGANIZATIONCURRENCY
        from
            dbo.CURRENCY
        inner join
            dbo.LOCALE on LOCALE.ID = CURRENCY.LOCALEID
        where
            @INCLUDEINACTIVE = 1 or CURRENCY.INACTIVE = 0
        order by 
            CURRENCY.NAME asc