I have big list of international phone codes and a smaller rate sheet from a phone company. I need to assign rates to my list. The difficulty is that our lists are different. In the following example I have 4 codes in my list and only 2 codes in a phone company's list. code 4478 has to get the rate $0.01 and code 44787210 has to get the rate $0.02 Thanks.
drop table #my_list drop table #phone_company_list