At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.
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.