USP_SIMPLEDATALIST_CURRENCYSETWITHBASECURRENCY

Generates the list of currencies that should be available when assigning a record a new base currency.

Definition



        create procedure dbo.USP_SIMPLEDATALIST_CURRENCYSETWITHBASECURRENCY
        as
              select 
                  CURRENCYSET.ID as VALUE,
                  dbo.UFN_CURRENCYSET_GETBASECURRENCYDESCRIPTION(CURRENCYSET.ID) as LABEL
              from
                  dbo.CURRENCYSET
              order by
                  LABEL;