Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clement.store
Starting Member
25 Posts |
 Posted - 2009-10-30 : 21:16:50
|
| Hello all,I m working on Business OBjects reports involving multi currency which are updated on a monthly basis. I wonder which of the following design would work better.. or even another new design.I m receiving balances from diff countries of in their base currencies e.g. USD, YEN, RMB ... I m converting these mostly (95% instance) to HKD which has the following table in use already. However, WOuld u pls let me know if u have a better solution... or the usualpractice..?HKD USD SGD YEN 1-Dec-95 7.7325 5.4912 0.07551-Jan-96 7.7330 5.5032 0.07221-Feb-96 7.7317 5.4905 0.07411-Mar-96 7.7352 5.5125 0.07231-Apr-96 7.7352 5.5205 0.07411-May-96 7.7377 5.5105 0.07211-Jun-96 7.7415 5.5103 0.07091-Jul-96 7.7335 5.4877 0.07191-Aug-96 7.7330 5.4932 0.07151-Sep-96 7.7340 5.5136 0.0699thanks a lot!Clement |
|
|
|
|
|
Database design for currency rate