Working with two tables in Request!!! Any alternative solution?
679500Aug 5 2010 — edited Aug 6 2010Hi All,
I am stuck with a requirement, it is as follows,
I have one table say Table1 with DATE,CYRRENCY and AMOUNT . User will select a date, we need to get all records greater than date selected by user from Table 1.
Now I need to get exchang rate and currency for the date selected by user from other table say Table2 which has got details DATE, CURRENCY and EXCHANAGE RATE.
Next step will be, Amount*Exchange Rate will be shown Currency wise.
we need to do this calculation at run time based on date selected by user.
I tried to do this in many ways like union query, changing data model at ETL layer etc. But not able to achieve.
Your valuable suggestions would help me.
Thanks.