Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
select distinct a.DateKey as CalendarDate , fx.NumeratorCurrCode as ISO_Curr , fx.SpotRate , fx.Mod_SpotRate from AdvDateList a left outer join (select NumeratorCurrCode, DenominatorCurrCode , AsOfDate, SpotRate, 1/SpotRate as Mod_SpotRate -- Mod_SpotRate from APX.FxRateHistory fx where NumeratorCurrCode in ('gb','eu') and DenominatorCurrCode = 'us' ) fx on a.DateKey = fx.AsOfDate where a.DateKey between (getdate()-6) and (getdate()-1) -- returns previous 5 days
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.