SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE YourRateTable (Currency char(3), Rate decimal(18,9))
DECLARE @xml xml = '<?xml version="1.0" encoding="UTF-8"?>
<gesmes:Envelope xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01" xmlns="http://www.ecb.int/vocabulary/2002-08-01/eurofxref">
    <gesmes:subject>Reference rates</gesmes:subject>
    <gesmes:Sender>
        <gesmes:name>European Central Bank</gesmes:name>
    </gesmes:Sender>
    <Cube>
        <Cube time=''2021-11-12''>
            <Cube currency=''USD'' rate=''1.1448''/>
            <Cube currency=''JPY'' rate=''130.50''/>
            <Cube currency=''BGN'' rate=''1.9558''/>
            <Cube currency=''CZK'' rate=''25.238''/>
            <Cube currency=''DKK'' rate=''7.4370''/>
            <Cube currency=''GBP'' rate=''0.85505''/>
            <Cube currency=''HUF'' rate=''366.15''/>
            <Cube currency=''PLN'' rate=''4.6428''/>
            <Cube currency=''RON'' rate=''4.9488''/>
            <Cube currency=''SEK'' rate=''10.0085''/>
            <Cube currency=''CHF'' rate=''1.0568''/>
            <Cube currency=''ISK'' rate=''150.40''/>
            <Cube currency=''NOK'' rate=''9.9508''/>
            <Cube currency=''HRK'' rate=''7.5123''/>
            <Cube currency=''RUB'' rate=''82.6649''/>
            <Cube currency=''TRY'' rate=''11.3987''/>
            <Cube currency=''AUD'' rate=''1.5690''/>
            <Cube currency=''BRL'' rate=''6.1902''/>
            <Cube currency=''CAD'' rate=''1.4416''/>
            <Cube currency=''CNY'' rate=''7.3047''/>
            <Cube currency=''HKD'' rate=''8.9206''/>
            <Cube currency=''IDR'' rate=''16239.91''/>
            <Cube currency=''ILS'' rate=''3.5600''/>
            <Cube currency=''INR'' rate=''85.1930''/>
            <Cube currency=''KRW'' rate=''1349.10''/>
            <Cube currency=''MXN'' rate=''23.6472''/>
            <Cube currency=''MYR'' rate=''4.7692''/>
            <Cube currency=''NZD'' rate=''1.6293''/>
            <Cube currency=''PHP'' rate=''56.995''/>
            <Cube currency=''SGD'' rate=''1.5494''/>
            <Cube currency=''THB'' rate=''37.527''/>
            <Cube currency=''ZAR'' rate=''17.4919''/>
        </Cube>
    </Cube>
</gesmes:Envelope>
';


WITH XMLNAMESPACES(
  DEFAULT 'http://www.ecb.int/vocabulary/2002-08-01/eurofxref',
  'http://www.gesmes.org/xml/2002-08-01' AS gesmes)
INSERT YourRateTable (Currency, Rate)
SELECT
  x.cube.value('@currency','char(3)'),
  x.cube.value('@rate','decimal(18,9)')
FROM @xml.nodes('/gesmes:Envelope/Cube/Cube/Cube') x(cube)
32 rows affected

SELECT *
FROM YourRateTable


Currency
Rate


USD
1.144800000

JPY
130.500000000

BGN
1.955800000

CZK
25.238000000

DKK
7.437000000

GBP
0.855050000

HUF
366.150000000

PLN
4.642800000

RON
4.948800000

SEK
10.008500000

CHF
1.056800000

ISK
150.400000000

NOK
9.950800000

HRK
7.512300000

RUB
82.664900000

TRY
11.398700000

AUD
1.569000000

BRL
6.190200000

CAD
1.441600000

CNY
7.304700000

HKD
8.920600000

IDR
16239.910000000

ILS
3.560000000

INR
85.193000000

KRW
1349.100000000

MXN
23.647200000

MYR
4.769200000

NZD
1.629300000

PHP
56.995000000

SGD
1.549400000

THB
37.527000000

ZAR
17.491900000

Currency	Rate
USD	1.144800000
JPY	130.500000000
BGN	1.955800000
CZK	25.238000000
DKK	7.437000000
GBP	0.855050000
HUF	366.150000000
PLN	4.642800000
RON	4.948800000
SEK	10.008500000
CHF	1.056800000
ISK	150.400000000
NOK	9.950800000
HRK	7.512300000
RUB	82.664900000
TRY	11.398700000
AUD	1.569000000
BRL	6.190200000
CAD	1.441600000
CNY	7.304700000
HKD	8.920600000
IDR	16239.910000000
ILS	3.560000000
INR	85.193000000
KRW	1349.100000000
MXN	23.647200000
MYR	4.769200000
NZD	1.629300000
PHP	56.995000000
SGD	1.549400000
THB	37.527000000
ZAR	17.491900000