The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
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
|SQL Server 2012 r2 - Make Temp Table Query Faster||5||50|
|SQL group by query to return records with highest value||6||25|
|sql server query||12||26|
|reccommendations for a free msft sql query manager?||4||28|