June 11, 2008 at 11:53 pm
Dear Friends
I have the Table with two columns.
Column1=AMOUNT.
COLUMN2=CURRANCY_CODE.
i WILL HAVE TO FIND OUT THE CURRENCY CONVERTION RATE TO INDIAN RUPPES(INR) IF THE CURRANCY_CODE IS NOT INR..
Sammple acct_crncy_code data=(EUR,EUR,GBP,USD etc)
so i will have to find the convertion rate from EUR to INR etc.
HOW SHOULD I PROCEED TO SOLVE THIS?
PLZ HELP ME.
June 12, 2008 at 1:14 am
I would have a lookup table containing the various currency codes with their conversion rate to IPR
~PD
June 12, 2008 at 10:40 pm
As an exercise, yes, you'd probably build your own conversion rates table. From there, you'll have lots of choices on correlating the data. If, as I suspect, this is a class project, my main advice is to use the power of SQL and not think in procedural terms as you might if writing a program.
In the "real world", however, your main task would be to consider how you keep that data current. Within a financial instittution, you'll probably find an "official' exchange rate source. If this is a real project for some other type of business, you may want to explore how to get up to the minute data from one of the banks your employer or client does business with.
June 12, 2008 at 11:18 pm
Yeah I got the solution
I got an "official' exchange rate source from client.
Thanks for u r response..
Thank u so much
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply