USP_CURRENCYSET_DATALIST

                CREATE procedure dbo.USP_CURRENCYSET_DATALIST
                as
                    set nocount on;

                    select
                        CURRENCYSET.ID,
                        CURRENCYSET.NAME,
                        dbo.UFN_CURRENCY_GETDESCRIPTION(CURRENCYSET.BASECURRENCYID) as BASECURRENCY,
                        (select dbo.UDA_BUILDLIST(dbo.UFN_CURRENCY_GETDESCRIPTION(CURRENCYSETTRANSACTIONCURRENCY.CURRENCYID)) from dbo.CURRENCYSETTRANSACTIONCURRENCY where CURRENCYSETTRANSACTIONCURRENCY.CURRENCYSETID = CURRENCYSET.ID) as TRANSACTIONCURRENCIES,
                        CURRENCYSET.ISAPPUSERDEFAULT
                    from
                        dbo.CURRENCYSET
                    order by 
                        CURRENCYSET.ISAPPUSERDEFAULT DESC,CURRENCYSET.NAME