CurrencyReference Table

 -- Create the CurrencyReference table

CREATE TABLE CurrencyReference (

    CurrencyDescription NVARCHAR(100),

    CurrencyShortName CHAR(3)

);


-- Insert all possible currency descriptions and their corresponding ISO codes

INSERT INTO CurrencyReference (CurrencyDescription, CurrencyShortName) VALUES

    ('Afghan Afghani', 'AFN'),

    ('Albanian Lek', 'ALL'),

    ('Algerian Dinar', 'DZD'),

    ('Angolan Kwanza', 'AOA'),

    ('Argentine Peso', 'ARS'),

    ('Armenian Dram', 'AMD'),

    ('Aruban Florin', 'AWG'),

    ('Australian Dollar', 'AUD'),

    ('Azerbaijani Manat', 'AZN'),

    ('Bahamian Dollar', 'BSD'),

    ('Bahraini Dinar', 'BHD'),

    ('Bangladeshi Taka', 'BDT'),

    ('Barbadian Dollar', 'BBD'),

    ('Belarusian Ruble', 'BYN'),

    ('Belize Dollar', 'BZD'),

    ('Bermudian Dollar', 'BMD'),

    ('Bhutanese Ngultrum', 'BTN'),

    ('Bolivian Boliviano', 'BOB'),

    ('Bosnia-Herzegovina Convertible Mark', 'BAM'),

    ('Botswana Pula', 'BWP'),

    ('Brazilian Real', 'BRL'),

    ('British Pound Sterling', 'GBP'),

    ('Brunei Dollar', 'BND'),

    ('Bulgarian Lev', 'BGN'),

    ('Burundian Franc', 'BIF'),

    ('Cabo Verdean Escudo', 'CVE'),

    ('Cambodian Riel', 'KHR'),

    ('Canadian Dollar', 'CAD'),

    ('Cayman Islands Dollar', 'KYD'),

    ('Central African CFA Franc', 'XAF'),

    ('Chilean Peso', 'CLP'),

    ('Chinese Yuan', 'CNY'),

    ('Colombian Peso', 'COP'),

    ('Comorian Franc', 'KMF'),

    ('Congolese Franc', 'CDF'),

    ('Costa Rican Colón', 'CRC'),

    ('Croatian Kuna', 'HRK'),

    ('Cuban Peso', 'CUP'),

    ('Czech Koruna', 'CZK'),

    ('Danish Krone', 'DKK'),

    ('Djiboutian Franc', 'DJF'),

    ('Dominican Peso', 'DOP'),

    ('East Caribbean Dollar', 'XCD'),

    ('Egyptian Pound', 'EGP'),

    ('Eritrean Nakfa', 'ERN'),

    ('Estonian Kroon', 'EEK'),

    ('Ethiopian Birr', 'ETB'),

    ('Euro', 'EUR'),

    ('Fijian Dollar', 'FJD'),

    ('Gambian Dalasi', 'GMD'),

    ('Georgian Lari', 'GEL'),

    ('Ghanaian Cedi', 'GHS'),

    ('Gibraltar Pound', 'GIP'),

    ('Guatemalan Quetzal', 'GTQ'),

    ('Guinean Franc', 'GNF'),

    ('Guyanese Dollar', 'GYD'),

    ('Haitian Gourde', 'HTG'),

    ('Honduran Lempira', 'HNL'),

    ('Hong Kong Dollar', 'HKD'),

    ('Hungarian Forint', 'HUF'),

    ('Icelandic Króna', 'ISK'),

    ('Indian Rupee', 'INR'),

    ('Indonesian Rupiah', 'IDR'),

    ('Iranian Rial', 'IRR'),

    ('Iraqi Dinar', 'IQD'),

    ('Israeli New Shekel', 'ILS'),

    ('Jamaican Dollar', 'JMD'),

    ('Japanese Yen', 'JPY'),

    ('Jordanian Dinar', 'JOD'),

    ('Kazakhstani Tenge', 'KZT'),

    ('Kenyan Shilling', 'KES'),

    ('Kuwaiti Dinar', 'KWD'),

    ('Kyrgyzstani Som', 'KGS'),

    ('Lao Kip', 'LAK'),

    ('Latvian Lats', 'LVL'),

    ('Lebanese Pound', 'LBP'),

    ('Lesotho Loti', 'LSL'),

    ('Liberian Dollar', 'LRD'),

    ('Libyan Dinar', 'LYD'),

    ('Lithuanian Litas', 'LTL'),

    ('Macanese Pataca', 'MOP'),

    ('Macedonian Denar', 'MKD'),

    ('Malagasy Ariary', 'MGA'),

    ('Malawian Kwacha', 'MWK'),

    ('Malaysian Ringgit', 'MYR'),

    ('Maldivian Rufiyaa', 'MVR'),

    ('Mauritanian Ouguiya', 'MRU'),

    ('Mauritian Rupee', 'MUR'),

    ('Mexican Peso', 'MXN'),

    ('Moldovan Leu', 'MDL'),

    ('Mongolian Tögrög', 'MNT'),

    ('Moroccan Dirham', 'MAD'),

    ('Mozambican Metical', 'MZN'),

    ('Myanmar Kyat', 'MMK'),

    ('Namibian Dollar', 'NAD'),

    ('Nepalese Rupee', 'NPR'),

    ('Netherlands Antillean Guilder', 'ANG'),

    ('New Zealand Dollar', 'NZD'),

    ('Nicaraguan Córdoba', 'NIO'),

    ('Nigerian Naira', 'NGN'),

    ('North Korean Won', 'KPW'),

    ('Norwegian Krone', 'NOK'),

    ('Omani Rial', 'OMR'),

    ('Pakistani Rupee', 'PKR'),

    ('Panamanian Balboa', 'PAB'),

    ('Papua New Guinean Kina', 'PGK'),

    ('Paraguayan Guaraní', 'PYG'),

    ('Peruvian Sol', 'PEN'),

    ('Philippine Peso', 'PHP'),

    ('Polish Złoty', 'PLN'),

    ('Qatari Riyal', 'QAR'),

    ('Romanian Leu', 'RON'),

    ('Russian Ruble', 'RUB'),

    ('Rwandan Franc', 'RWF'),

    ('Saint Helena Pound', 'SHP'),

    ('Samoan Tala', 'WST'),

    ('São Tomé and Príncipe Dobra', 'STN'),

    ('Saudi Riyal', 'SAR'),

    ('Serbian Dinar', 'RSD'),

    ('Seychellois Rupee', 'SCR'),

    ('Sierra Leonean Leone', 'SLL'),

    ('Singapore Dollar', 'SGD'),

    ('Solomon Islands Dollar', 'SBD'),

    ('Somali Shilling', 'SOS'),

    ('South African Rand', 'ZAR'),

    ('South Korean Won', 'KRW'),

    ('South Sudanese Pound', 'SSP'),

    ('Sri Lankan Rupee', 'LKR'),

    ('Sudanese Pound', 'SDG'),

    ('Surinamese Dollar', 'SRD'),

    ('Swazi Lilangeni', 'SZL'),

    ('Swedish Krona', 'SEK'),

    ('Swiss Franc', 'CHF'),

    ('Syrian Pound', 'SYP'),

    ('Taiwan Dollar', 'TWD'),

    ('Tajikistani Somoni', 'TJS'),

    ('Tanzanian Shilling', 'TZS'),

    ('Thai Baht', 'THB'),

    ('Tongan Paʻanga', 'TOP'),

    ('Trinidad and Tobago Dollar', 'TTD'),

    ('Tunisian Dinar', 'TND'),

    ('Turkish Lira', 'TRY'),

    ('Turkmenistani Manat', 'TMT'),

    ('Ugandan Shilling', 'UGX'),

    ('Ukrainian Hryvnia', 'UAH'),

    ('United Arab Emirates Dirham', 'AED'),

    ('United States Dollar', 'USD'),

    ('Uruguayan Peso', 'UYU'),

    ('Uzbekistani Som', 'UZS'),

    ('Vanuatu Vatu', 'VUV'),

    ('Venezuelan Bolívar', 'VES'),

    ('Vietnamese Đồng', 'VND'),

    ('Yemeni Rial', 'YER'),

    ('Zambian Kwacha', 'ZMW'),

    ('Zimbabwean Dollar', 'ZWL');


Comments

Post a Comment

Popular posts from this blog

host

import pandas as pd from datetime import datetime import os # Example DataFrame df_final = pd.DataFrame({     'Name': ['Alice', 'Bob', 'Charlie'],     'Age': [25, 30, 35],     'City': ['New York', 'Los Angeles', 'Chicago'] }) # Generate today's date in 'YYYY-MM-DD' format today = datetime.now().strftime("%Y-%m-%d") # Create a dynamic filename filename = f"{today}_data.csv" # Network drive path (Windows) network_folder = r"\\network_drive\shared_folder" # Full path to save the file full_path = os.path.join(network_folder, filename) # Save DataFrame to CSV try:     df_final.to_csv(full_path, index=False)     print(f"File saved successfully to {full_path}") except Exception as e:     print(f"Error saving file: {e}")
Read more

Steps to create SSH key from git bash

Generating an SSH key in OpenSSH involves a few simple steps. Here’s how you can do it: 1. Open a Terminal If you're on Linux or macOS, you can use the built-in terminal. On Windows, you can use the Command Prompt, PowerShell, or Git Bash if you have Git installed. 2. Generate the SSH Key Pair Run the following command: bash Copy code ssh-keygen -t rsa -b 4096 -C "your_email@example.com" Here’s what each option means: -t rsa : Specifies the type of key to create, in this case, RSA. -b 4096 : Specifies the number of bits in the key, 4096 bits is a good choice for strong encryption. -C "your_email@example.com" : Adds a label to the key, usually your email address. 3. Choose a File Location After running the above command, you'll be prompted to choose a location to save the key. By default, it will be saved in ~/.ssh/id_rsa (on Linux or macOS) or in C:\Users\YourUserName\.ssh\id_rsa (on Windows). Press Enter to accept the default location, or specify a diff...
Read more

test

.. https://ubiquis.co.uk/loading-csv-files-with-pdi-metadata-injection-2/ -- Create a temporary table to demonstrate the solution CREATE TABLE YourTable ( ID INT, YourColumn VARCHAR(100) ); -- Insert sample data INSERT INTO YourTable (ID, YourColumn) VALUES (1, '1234_4567_abc'), (2, '789_012_def'), (3, 'xyz'); -- Declare variables for storing results DECLARE @firstPart VARCHAR(100), @secondPart VARCHAR(100); -- Iterate over rows in the table DECLARE @currentID INT = 1; DECLARE @rowCount INT = (SELECT COUNT(*) FROM YourTable); WHILE @currentID <= @rowCount BEGIN -- Retrieve input string from the table DECLARE @inputString VARCHAR(100); SELECT @inputString = YourColumn FROM YourTable WHERE ID = @currentID; -- Check if the delimiter exists in the input string IF CHARINDEX('_', @inputString) > 0 BEGIN -- Find the position of the first occurrence of the delimiter in the input string DECLARE @delimiter...
Read more