![]() ![]() step5: Divide USD Amount with result from step 4Īny help is appreciated. step4: Get conversion rate for **DestinationCurrency** step3 : Multiply with amount (Here we have USD value for amount) step2 : Get conversition rate for **Amountcurrency** using select query to table2 ![]() I was thinking to have a loop like, While (Select Count(*) From Table1) > 0 What is the best way to iterate Table1 rows and do the conversion and update it in CalculateAmountInDestinationCurrency column. My Table1 has around 10000 rows and Table2 has conversion rate for all the currencies for all dates till now. Since we want to convert it to CAD get conversion rate for 1 CAD on given conversion_date, 1 CAD = 0.9399380000 USD, now we need to convert 1.60752 USD to CAD that can be done by dividing it with CAD rate i.e 1.60752/1.60752 = 1.71024 CAD. something like, select Rate from Table1 where converstion_Date = '' and Currency = 'INR'.Ībove query will give me 0.0160752000 and we will convert INR TO USD i.e Disclaimer: Currency.wiki exchange rates are for. Printable Version Are you traveling and want to plan for the currency conversions in the country of destination This currency tool comes with a printable version for any currency pairs. Second table presents all possible exchange rates to Bitcoin (BTC). Numeric Format The currency converter also comes with the option of choosing decimal separator and thousands separator. First table lists exchange rates (quotations) of the most popular currencies to Bitcoin (BTC). As per math I will get conversation rate for 1 INR on given conversion_date from Table2 multiple it by AmountCurrency. Emoji: Main attention is drawn to BTC exchange rate Bitcoin and currency converter. Ĭonvert Amount from amountCurrency to destination currency and update it in last column of Table1Įxample : Amount in row one of Table1 is in INR and I want to convert it to CAD. I have two tables, Table1 with amount, amountCurrency and destination currency and Table2 have the conversion rate(As mentioned in image conversation rate are in terms of USD). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |