Realized Design: Currency Code Dimension or Lookup Table

Periodically, I need to create a currency code table. Currency codes follow the ISO 4217 standard. You can read more about the standard at ISO 4217. And if you ever need to get an updated value, or make changes, this is a good place to start. You can also use the ISO 4217 Wikipedia page.

Below is both the DDL used to create the currency table, along with the DML to do the initial population. This is from 2012, so review the listing and make any adjustments that may be needed.

I've also included a CountryKey column in the table. Typically, this is used to denote the country that issues the currency. Or in the case of the Euro, the organization. You will need a many-to-many table to define the full list of countries and the currency used.

       
use yourdatabase;
go


if exists (select * from sys.objects where object_id = object_id(N'dbo.Currency'))
  drop table dbo.Currency
  go

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

 CREATE TABLE dbo.Currency
 (
     CurrencyKey    smallint  IDENTITY (1,1) ,
     CountryKey    smallint  NOT NULL ,  -- issue country
     CurrencyA3Code  nvarchar(3) NOT NULL ,
     CurrencyNumCode nvarchar(10)  NULL ,
     Currency_Name   nvarchar(100)  NULL ,
     CountryDesc    nvarchar(100)  NULL ,     
     SortOrder     smallint  NOT NULL ,
     CONSTRAINT  PK_Currency_CurrencyKey PRIMARY KEY clustered (CurrencyKey  ASC)
 )
 go


  -- AK
  CREATE  UNIQUE INDEX AK_Currency_A3 ON dbo.Currency ( CurrencyA3Code  ASC )
  go

The following DML populates the currency table. I always use the integer value 0 (zero) to denote an unknown value.

       

use yourdatabase;
go

-- truncate table dbo.Currency;

/*
ISO 4217 Currency codes as of 2012, update as needed

 See URL for updated/current values
  http://www.iso.org/iso/home/standards/currency_codes.htm
  https://en.wikipedia.org/wiki/ISO_4217
  
*/

-----
SET IDENTITY_INSERT dbo.Currency On
-- unknown
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc, CurrencyNumCode)values ( 0, 0, 'n/a' , 'unknown', 0, 'A', '000'  );
-- all others
-- insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  1, 0, '-','unknown',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  2, 0, 'AFA','Afghani',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  3, 0, 'DZD','Algerian Dinar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  4, 0, 'ADP','Andorran Peseta',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  5, 0, 'ARS','Argentine Peso',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  6, 0, 'AMD','Armenian Dram',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  7, 0, 'AWG','Aruban Guilder',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  8, 0, 'AUD','Australian Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  9, 0, 'AZM','Azerbaijanian Manat',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  10, 0, 'BSD','Bahamian Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  11, 0, 'BHD','Bahraini Dinar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  12, 0, 'THB','Baht',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  13, 0, 'PAB','Balboa',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  14, 0, 'BBD','Barbados Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  15, 0, 'BYB','Belarussian Ruble',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  16, 0, 'BEF','Belgian Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  17, 0, 'BZD','Belize Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  18, 0, 'BMD','Bermudian Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  19, 0, 'VEB','Bolivar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  20, 0, 'BOB','Boliviano',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  21, 0, 'BRL','Brazilian Real',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  22, 0, 'BND','Brunei Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  23, 0, 'BIF','Burundi Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  24, 0, 'CAD','Canadian Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  25, 0, 'CVE','Cape Verde Escudo',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  26, 0, 'KYD','Cayman Islands Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  27, 0, 'GHC','Cedi',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  28, 0, 'XOF','CFA Franc BCEAO',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  29, 0, 'XAF','CFA Franc BEAC',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  30, 0, 'XPF','CFP Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  31, 0, 'CLP','Chilean Peso',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  32, 0, 'COP','Colombian Peso',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  33, 0, 'KMF','Comoro Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  34, 0, '---','Convertible Mark',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  35, 0, 'NIO','Cordoba Oro',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  36, 0, 'CRC','Costa Rican Colon',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  37, 0, 'CUP','Cuban Peso',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  38, 0, 'CYP','Cyprus Pound',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  39, 0, 'CZK','Czech Koruna',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  40, 0, 'GMD','Dalasi',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  41, 0, 'DKK','Danish Krone',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  42, 0, 'MKD','Denar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  43, 0, 'DEM','Deutsche Mark',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  44, 0, 'DJF','Djibouti Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  45, 0, 'STD','Dobra',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  46, 0, 'DOP','Dominican Peso',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  47, 0, 'VND','Dong',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  48, 0, 'GRD','Drachma',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  49, 0, 'XCD','East Caribbean Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  50, 0, 'XCD','East Carribean Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  51, 0, 'XEU','ECU (until 1998-12-31)',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  52, 0, 'EGP','Egyptian Pound',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  53, 0, 'SVC','El Salvador Colon',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  54, 0, 'ETB','Ethiopian Birr',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  55, 0, 'EUR','Euro',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  56, 0, 'FKP','Falkland Islands Pound',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  57, 0, 'FJD','Fiji Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  58, 0, 'ZAL','Financial Rand',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  59, 0, 'HUF','Forint',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  60, 0, 'FRF','French Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  61, 0, 'GIP','Gibraltar Pound',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  62, 0, 'HTG','Gourde',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  63, 0, 'PYG','Guarani',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  64, 0, 'GNF','Guinea Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  65, 0, 'GWP','Guinea-Bissau Peso',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  66, 0, 'GYD','Guyana Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  67, 0, 'HKD','Hong Kong Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  68, 0, 'UAH','Hryvnya',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  69, 0, 'ISK','Iceland Krona',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  70, 0, 'INR','Indian Rupee',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  71, 0, 'IRR','Iranian Rial',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  72, 0, 'IQD','Iraqi Dinar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  73, 0, 'IEP','Irish Pound',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  74, 0, 'ITL','Italian Lira',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  75, 0, 'JMD','Jamaican Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  76, 0, 'JOD','Jordanian Dinar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  77, 0, 'UAK','Karbovanets',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  78, 0, 'KES','Kenyan Shilling',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  79, 0, 'PGK','Kina',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  80, 0, 'LAK','Kip',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  81, 0, 'EEK','Kroon',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  82, 0, 'HRK','Kuna',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  83, 0, 'KWD','Kuwaiti Dinar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  84, 0, 'ZMK','Kwacha',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  85, 0, 'MWK','Kwacha',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  86, 0, 'AOR','Kwanza Reajustado',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  87, 0, 'MMK','Kyat',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  88, 0, 'GEL','Lari',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  89, 0, 'LVL','Latvian Lats',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  90, 0, 'LBP','Lebanese Pound',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  91, 0, 'ALL','Lek',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  92, 0, 'HNL','Lempira',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  93, 0, 'SLL','Leone',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  94, 0, 'ROL','Leu',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  95, 0, 'BGL','Lev',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  96, 0, 'LRD','Liberian Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  97, 0, 'LYD','Libyan Dinar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  98, 0, 'SZL','Lilangeni',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  99, 0, 'LTL','Lithuanian Litas',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  100, 0, 'LSL','Loti',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  101, 0, 'LUF','Luxembourg Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  102, 0, 'MGF','Malagasy Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  103, 0, 'MYR','Malaysian Ringgit',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  104, 0, 'MTL','Maltese Lira',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  105, 0, 'TMM','Manat',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  106, 0, 'FIM','Markka',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  107, 0, 'MUR','Mauritius Rupee',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  108, 0, 'MZM','Metical',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  109, 0, 'MXN','Mexican Nuevo Peso',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  110, 0, 'MDL','Moldovan Leu',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  111, 0, 'MAD','Moroccan Dirham',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  112, 0, 'BOV','MVDol',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  113, 0, 'NGN','Naira',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  114, 0, 'NAD','Namibia Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  115, 0, 'NPR','Nepalese Rupee',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  116, 0, 'ANG','Netherlands Antillean Guilder',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  117, 0, 'NLG','Netherlands Guilder',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  118, 0, 'YUM','New Dinar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  119, 0, 'AON','New Kwanza',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  120, 0, 'TWD','New Taiwan Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  121, 0, 'ZRN','New Zaire',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  122, 0, 'NZD','New Zealand Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  123, 0, 'BTN','Ngultrum',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  124, 0, 'KPW','North Korean Won',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  125, 0, 'NOK','Norwegian Krone',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  126, 0, 'PEN','Nuevo Sol',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  127, 0, 'MRO','Ouguiya',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  128, 0, 'TOP','Pa anga',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  129, 0, 'PKR','Pakistan Rupee',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  130, 0, 'MOP','Pataca',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  131, 0, 'UYU','Peso Uruguayo',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  132, 0, 'PHP','Philippine Peso',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  133, 0, 'PTE','Portuguese Escudo',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  134, 0, 'GBP','Pound Sterling',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  135, 0, 'BWP','Pula',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  136, 0, 'QAR','Qatari Rial',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  137, 0, 'GTQ','Quetzal',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  138, 0, 'ZAR','Rand',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  139, 0, 'OMR','Rial Omani',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  140, 0, 'KHR','Riel',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  141, 0, 'MVR','Rufiyaa',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  142, 0, 'IDR','Rupiah',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  143, 0, 'RUR','Russian Ruble',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  144, 0, 'RWF','Rwanda Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  145, 0, 'SAR','Saudi Riyal',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  146, 0, 'SCR','Seychelles Rupee',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  147, 0, 'ILS','Shekel',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  148, 0, 'ATS','Shilling',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  149, 0, 'SGD','Singapore Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  150, 0, 'SKK','Slovak Koruna',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  151, 0, 'SBD','Solomon Islands Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  152, 0, 'KGS','Som',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  153, 0, 'SOS','Somali Shilling',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  154, 0, 'ESP','Spanish Peseta',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  155, 0, 'LKR','Sri Lanka Rupee',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  156, 0, 'SHP','St. Helena Pound',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  157, 0, 'ECS','Sucre',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  158, 0, 'SDD','Sudanese Dinar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  159, 0, 'SRG','Surinam Guilder',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  160, 0, 'SEK','Swedish Krona',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  161, 0, 'CHF','Swiss Franc',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  162, 0, 'SYP','Syrian Pound',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  163, 0, 'TJR','Tajik Ruble',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  164, 0, 'BDT','Taka',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  165, 0, 'WST','Tala',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  166, 0, 'TZS','Tanzanian Shilling',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  167, 0, 'KZT','Tenge',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  168, 0, 'TPE','Timor Escudo',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  169, 0, 'SIT','Tolar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  170, 0, 'TTD','Trinidad and Tobago Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  171, 0, 'MNT','Tugrik',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  172, 0, 'TND','Tunisian Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  173, 0, 'TRL','Turkish Lira',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  174, 0, 'AED','UAE Dirham',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  175, 0, 'UGX','Uganda Shilling',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  176, 0, 'ECV','Unidad de Valor Constante (UVC)',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  177, 0, 'CLF','Unidades de Formento',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  178, 0, 'USD','US Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  179, 0, 'UZS','Uzbekistan Sum',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  180, 0, 'VUV','Vatu',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  181, 0, 'KRW','Won',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  182, 0, 'YER','Yemeni Rial',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  183, 0, 'JPY','Yen',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  184, 0, 'CNY','Yuan Renminbi',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  185, 0, 'ZWD','Zimbabwe Dollar',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  186, 0, 'PLZ','Zloty (PLZ)',10, 'A' ); 
insert into dbo.Currency ( CurrencyKey, CountryKey, CurrencyA3Code, Currency_Name,SortOrder, CountryDesc) values (  187, 0, 'PLN','Zloty (PLN)',10, 'A' ); 

SET IDENTITY_INSERT dbo.Currency Off

select * from dbo.Currency;

Pages

Tuesday, April 5, 2016

Currency Code Dimension or Lookup Table

No comments: