Can anyone help with the sql to create a multi currency exchange rate reporting view to support multiple databases? We are trying to build a reporting structure across our databases to get a global view of our business and need to convert foreign transactions to USD.
Thanks in advance.
Thanks in advance.