The following script (https://www.xsql.com/public/download/scripts/currencies.zip ) creates a "currencies" table and populates it with the complete ISO 4217 list of international currency codes (edition ISO 4217:2008).
Note that the first two letters of the [AlphabeticCode] in the Currencies table correspond to the [ISO_ALPHA2] code on the Countries table which you can get from http://blog.xsql.com/2012/10/t-sql-list-of-countries.html, whereas the [NumericCode] in the Currencies table is in most cases the same as the [NumericalCode] in the Countries table.
Please not that the list is current as of the date of this post.
If you have any questions or comments please post them here.
Note that the first two letters of the [AlphabeticCode] in the Currencies table correspond to the [ISO_ALPHA2] code on the Countries table which you can get from http://blog.xsql.com/2012/10/t-sql-list-of-countries.html, whereas the [NumericCode] in the Currencies table is in most cases the same as the [NumericalCode] in the Countries table.
Please not that the list is current as of the date of this post.
If you have any questions or comments please post them here.
u r awesome :)
ReplyDelete