I have transaction table and a exchange rate table.
My problem is how to get the right exchange rate for every transaction ?
1. If TrsDate = ExchangeDate then get the ExchangeRate.
2. If TrsDate > ExchangeDate then get the latest ExchangeDate before the TrsDate's ExchangeRate.
How could I do it ?