USP_CURRENCYEXCHANGERATEDOWNLOADPROCESS_GETRATES

create procedure dbo.[USP_CURRENCYEXCHANGERATEDOWNLOADPROCESS_GETRATES]
(
  @ID uniqueidentifier
)
as
begin
    set nocount on;

  select
    [CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE].[ID],
    [CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE].[FROMCURRENCYID],
    [CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE].[TOCURRENCYID],
    [FROM].[ISO4217] as [FROMCURRENCY],
    [TO].[ISO4217] as [TOCURRENCY],
    [FROM].[INACTIVE] as [FROMINACTIVE],
    [TO].[INACTIVE] as [TOINACTIVE]
  from dbo.[CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE]
  inner join dbo.[CURRENCY] as [FROM] on [FROM].[ID] = [CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE].[FROMCURRENCYID]
  inner join dbo.[CURRENCY] as [TO] on [TO].[ID] = [CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE].[TOCURRENCYID]
  where [CURRENCYEXCHANGERATEDOWNLOADPROCESSID] = @ID;

    return 0;
end