1- why did you choose CurrencyAlternateKey , while we can choose CurrencyName and get the same result (not sure)? 2- is it similar to PARTITION BY in SQL?

Currency name will give you the full name of the currency such as United States Dollar, we don't want that, we just need the three letter abbreviation. Not sure what you mean about the partition?

Follow this topic