Hi, I have a couple of tables, Cash and FXRates. The Cash table gets populated daily via SSIS package import from CSV but column BaseCurrencyValue is always NULL.
I am looking for help on how to write an update query that will update the BaseCurrencyValue column for all records based on a lookup where Cash.Currency = FXRates.ToCurrency and returns the FXRate value which I then need to multiply against the Cash.Value field before updating that value into the BaseCurrencyValue field.
It's a simple currency conversion.
Here are the basic tables and data:
INSERT INTO Cash
INSERT INTO FXRates
Any help would be much appreciated as I have tried triggers and update queries to no avail.