USP_CURRENCY_GETCURRENCIES

Returns all currencies.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN

Definition

Copy



create procedure dbo.[USP_CURRENCY_GETCURRENCIES]
(
  @INCLUDEINACTIVE bit = 0
)
as
  set nocount on;

  select
    [ID],
    [NAME],
    [ISO4217]
  from dbo.[CURRENCY]
  where [INACTIVE] = 0 or @INCLUDEINACTIVE = 1
  order by [NAME];

  return 0;