SQL Server 2012

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table FBNK_PT_CURRENCY (RECID varchar(20), XMLRECORD xml);
INSERT INTO FBNK_PT_CURRENCY values ('VU0010002', '<row id="VU0010002" xml:space="preserve"><c2>20181210</c2><c3>AUD</c3><c3 m="2">EUR</c3><c3 m="3">FJD</c3><c3 m="4">GBP</c3><c3 m="5">HKD</c3><c3 m="6">JPY</c3><c3 m="7">NZD</c3><c3 m="8">PGK</c3><c3 m="9">SBD</c3><c3 m="10">SGD</c3><c3 m="11">USD</c3><c3 m="12">VUV</c3><c3 m="13">XPF</c3><c4>1</c4><c4 m="1" s="2">10</c4><c4 m="2">1</c4><c4 m="2" s="2">10</c4><c4 m="3">1</c4><c4 m="3" s="2">10</c4><c4 m="4">1</c4><c4 m="4" s="2">10</c4><c4 m="5">1</c4><c4 m="5" s="2">10</c4><c4 m="6">1</c4><c4 m="6" s="2">10</c4><c4 m="7">1</c4><c4 m="7" s="2">10</c4><c4 m="8">1</c4><c4 m="8" s="2">10</c4><c4 m="9">1</c4><c4 m="9" s="2">10</c4><c4 m="10">1</c4><c4 m="10" s="2">10</c4><c4 m="11">1</c4><c4 m="11" s="2">10</c4><c4 m="12">1</c4><c4 m="12" s="2">10</c4><c4 m="13">1</c4><c4 m="13" s="2">10</c4><c5 m="1" s="2"/><c5 m="2" s="2"/><c5 m="3" s="2"/><c5 m="4" s="2"/><c5 m="5" s="2"/><c5 m="6" s="2"/><c5 m="7" s="2"/><c5 m="8" s="2"/><c5 m="9" s="2"/><c5 m="10" s="2"/><c5 m="11" s="2"/><c5 m="12" s="2"/><c5 m="13" s="2"/><c6>80.98</c6><c6 m="1" s="2">80.98</c6><c6 m="2">128.39</c6><c6 m="2" s="2">128.39</c6><c6 m="3">53.22</c6><c6 m="3" s="2">53.22</c6><c6 m="4">143.07</c6><c6 m="4" s="2">143.07</c6><c6 m="5">14.46</c6><c6 m="5" s="2">14.46</c6><c6 m="6">1.0008</c6><c6 m="6" s="2">1.0008</c6><c6 m="7">77.26</c6><c6 m="7" s="2">77.26</c6><c6 m="8">34.34</c6><c6 m="8" s="2">34.34</c6><c6 m="9">14.64</c6><c6 m="9" s="2">14.64</c6><c6 m="10">82.41</c6><c6 m="10" s="2">82.41</c6><c6 m="11">112.6</c6><c6 m="11" s="2">112.6</c6><c6 m="12" s="2"/><c6 m="13">1.0746</c6><c6 m="13" s="2">1.0746</c6><c7>0</c7><c7 m="1" s="2">0</c7><c7 m="2">0</c7><c7 m="2" s="2">0</c7><c7 m="3">0</c7><c7 m="3" s="2">0</c7><c7 m="4">0</c7><c7 m="4" s="2">0</c7><c7 m="5">0</c7><c7 m="5" s="2">0</c7><c7 m="6">0</c7><c7 m="6" s="2">0</c7><c7 m="7">0</c7><c7 m="7" s="2">0</c7><c7 m="8">0</c7><c7 m="8" s="2">0</c7><c7 m="9">0</c7><c7 m="9" s="2">0</c7><c7 m="10">0</c7><c7 m="10" s="2">0</c7><c7 m="11">0</c7><c7 m="11" s="2">0</c7><c7 m="12" s="2"/><c7 m="13">0</c7><c7 m="13" s="2">0</c7><c8>80.08</c8><c8 m="1" s="2">79.39</c8><c8 m="2">127.17</c8><c8 m="2" s="2">119.52</c8><c8 m="3">51.58</c8><c8 m="3" s="2">49.99</c8><c8 m="4">141.73</c8><c8 m="4" s="2">134.44</c8><c8 m="5">13.79</c8><c8 m="5" s="2">11.12</c8><c8 m="6">0.9915</c8><c8 m="6" s="2">0.8796</c8><c8 m="7">76.58</c8><c8 m="7" s="2">74.19</c8><c8 m="8">32.25</c8><c8 m="8" s="2">25.71</c8><c8 m="9">13.97</c8><c8 m="9" s="2">13.97</c8><c8 m="10">81.42</c8><c8 m="10" s="2">64.46</c8><c8 m="11">111.43</c8><c8 m="11" s="2">109.05</c8><c8 m="12" s="2"/><c8 m="13">1.0646</c8><c8 m="13" s="2">0.938</c8><c9>84.37</c9><c9 m="1" s="2">84.37</c9><c9 m="2">132.17</c9><c9 m="2" s="2">132.17</c9><c9 m="3">55.57</c9><c9 m="3" s="2">55.57</c9><c9 m="4">146.31</c9><c9 m="4" s="2">146.31</c9><c9 m="5">15.16</c9><c9 m="5" s="2">15.16</c9><c9 m="6">1.038</c9><c9 m="6" s="2">1.038</c9><c9 m="7">80.89</c9><c9 m="7" s="2">80.89</c9><c9 m="8">35.85</c9><c9 m="8" s="2">35.85</c9><c9 m="9">15.84</c9><c9 m="9" s="2">15.84</c9><c9 m="10">85.2</c9><c9 m="10" s="2">85.2</c9><c9 m="11">117.6</c9><c9 m="11" s="2">117.6</c9><c9 m="12" s="2"/><c9 m="13">1.1119</c9><c9 m="13" s="2">1.1119</c9><c10 m="13"/><c11 m="13"/><c12 m="13"/><c13>100000.00</c13><c13 m="2">100000.00</c13><c13 m="13"/><c14 m="13"/><c15 m="13"/><c16 m="13"/><c18>795</c18><c19>102_JWABAIAT.1__OFS_BROWSERTC</c19><c20>1812101134</c20><c21>11_GARUKESA.1_OFS_BROWSERTC</c21><c22>VU0010001</c22><c23>8211</c23></row>')
1 rows affected

select * from FBNK_PT_CURRENCY


RECID
XMLRECORD


VU0010002
<row id="VU0010002" xml:space="preserve"><c2>20181210</c2><c3>AUD</c3><c3 m="2">EUR</c3><c3 m="3">FJD</c3><c3 m="4">GBP</c3><c3 m="5">HKD</c3><c3 m="6">JPY</c3><c3 m="7">NZD</c3><c3 m="8">PGK</c3><c3 m="9">SBD</c3><c3 m="10">SGD</c3><c3 m="11">USD</c3><c3 m="12">VUV</c3><c3 m="13">XPF</c3><c4>1</c4><c4 m="1" s="2">10</c4><c4 m="2">1</c4><c4 m="2" s="2">10</c4><c4 m="3">1</c4><c4 m="3" s="2">10</c4><c4 m="4">1</c4><c4 m="4" s="2">10</c4><c4 m="5">1</c4><c4 m="5" s="2">10</c4><c4 m="6">1</c4><c4 m="6" s="2">10</c4><c4 m="7">1</c4><c4 m="7" s="2">10</c4><c4 m="8">1</c4><c4 m="8" s="2">10</c4><c4 m="9">1</c4><c4 m="9" s="2">10</c4><c4 m="10">1</c4><c4 m="10" s="2">10</c4><c4 m="11">1</c4><c4 m="11" s="2">10</c4><c4 m="12">1</c4><c4 m="12" s="2">10</c4><c4 m="13">1</c4><c4 m="13" s="2">10</c4><c5 m="1" s="2" /><c5 m="2" s="2" /><c5 m="3" s="2" /><c5 m="4" s="2" /><c5 m="5" s="2" /><c5 m="6" s="2" /><c5 m="7" s="2" /><c5 m="8" s="2" /><c5 m="9" s="2" /><c5 m="10" s="2" /><c5 m="11" s="2" /><c5 m="12" s="2" /><c5 m="13" s="2" /><c6>80.98</c6><c6 m="1" s="2">80.98</c6><c6 m="2">128.39</c6><c6 m="2" s="2">128.39</c6><c6 m="3">53.22</c6><c6 m="3" s="2">53.22</c6><c6 m="4">143.07</c6><c6 m="4" s="2">143.07</c6><c6 m="5">14.46</c6><c6 m="5" s="2">14.46</c6><c6 m="6">1.0008</c6><c6 m="6" s="2">1.0008</c6><c6 m="7">77.26</c6><c6 m="7" s="2">77.26</c6><c6 m="8">34.34</c6><c6 m="8" s="2">34.34</c6><c6 m="9">14.64</c6><c6 m="9" s="2">14.64</c6><c6 m="10">82.41</c6><c6 m="10" s="2">82.41</c6><c6 m="11">112.6</c6><c6 m="11" s="2">112.6</c6><c6 m="12" s="2" /><c6 m="13">1.0746</c6><c6 m="13" s="2">1.0746</c6><c7>0</c7><c7 m="1" s="2">0</c7><c7 m="2">0</c7><c7 m="2" s="2">0</c7><c7 m="3">0</c7><c7 m="3" s="2">0</c7><c7 m="4">0</c7><c7 m="4" s="2">0</c7><c7 m="5">0</c7><c7 m="5" s="2">0</c7><c7 m="6">0</c7><c7 m="6" s="2">0</c7><c7 m="7">0</c7><c7 m="7" s="2">0</c7><c7 m="8">0</c7><c7 m="8" s="2">0</c7><c7 m="9">0</c7><c7 m="9" s="2">0</c7><c7 m="10">0</c7><c7 m="10" s="2">0</c7><c7 m="11">0</c7><c7 m="11" s="2">0</c7><c7 m="12" s="2" /><c7 m="13">0</c7><c7 m="13" s="2">0</c7><c8>80.08</c8><c8 m="1" s="2">79.39</c8><c8 m="2">127.17</c8><c8 m="2" s="2">119.52</c8><c8 m="3">51.58</c8><c8 m="3" s="2">49.99</c8><c8 m="4">141.73</c8><c8 m="4" s="2">134.44</c8><c8 m="5">13.79</c8><c8 m="5" s="2">11.12</c8><c8 m="6">0.9915</c8><c8 m="6" s="2">0.8796</c8><c8 m="7">76.58</c8><c8 m="7" s="2">74.19</c8><c8 m="8">32.25</c8><c8 m="8" s="2">25.71</c8><c8 m="9">13.97</c8><c8 m="9" s="2">13.97</c8><c8 m="10">81.42</c8><c8 m="10" s="2">64.46</c8><c8 m="11">111.43</c8><c8 m="11" s="2">109.05</c8><c8 m="12" s="2" /><c8 m="13">1.0646</c8><c8 m="13" s="2">0.938</c8><c9>84.37</c9><c9 m="1" s="2">84.37</c9><c9 m="2">132.17</c9><c9 m="2" s="2">132.17</c9><c9 m="3">55.57</c9><c9 m="3" s="2">55.57</c9><c9 m="4">146.31</c9><c9 m="4" s="2">146.31</c9><c9 m="5">15.16</c9><c9 m="5" s="2">15.16</c9><c9 m="6">1.038</c9><c9 m="6" s="2">1.038</c9><c9 m="7">80.89</c9><c9 m="7" s="2">80.89</c9><c9 m="8">35.85</c9><c9 m="8" s="2">35.85</c9><c9 m="9">15.84</c9><c9 m="9" s="2">15.84</c9><c9 m="10">85.2</c9><c9 m="10" s="2">85.2</c9><c9 m="11">117.6</c9><c9 m="11" s="2">117.6</c9><c9 m="12" s="2" /><c9 m="13">1.1119</c9><c9 m="13" s="2">1.1119</c9><c10 m="13" /><c11 m="13" /><c12 m="13" /><c13>100000.00</c13><c13 m="2">100000.00</c13><c13 m="13" /><c14 m="13" /><c15 m="13" /><c16 m="13" /><c18>795</c18><c19>102_JWABAIAT.1__OFS_BROWSERTC</c19><c20>1812101134</c20><c21>11_GARUKESA.1_OFS_BROWSERTC</c21><c22>VU0010001</c22><c23>8211</c23></row>


SELECT 
RECID as Branch,
XMLRECORD.value('(/row/c2/text())[1]', 'nvarchar(10)') as UpdateDate,
XMLRECORD.value('(/row/c3[@m="2"]/text())[1]', 'nvarchar(10)') as Currency,
XMLRECORD.value('(/row/c6[@m="2"]/text())[1]', 'nvarchar(10)') as [MidRevealRate_CCY_Market-CASH],
XMLRECORD.value('(/row/c8[@m="2"]/text())[1]', 'nvarchar(10)') as [BuyRate_CCY_Market-IFT],
XMLRECORD.value('(/row/c8[@m="2"][@s="2"]/text())[1]', 'nvarchar(10)') as [BuyRate_CCY_Market-CASH],
XMLRECORD.value('(/row/c9[@m="2"]/text())[1]', 'nvarchar(10)') as [SellRate_CCY_Market-CASH]
FROM [FBNK_PT_CURRENCY]
WHERE RECID in ('VU0010002')

UNION

SELECT 
RECID as Branch,
XMLRECORD.value('(/row/c2/text())[1]', 'nvarchar(10)') as UpdateDate,
XMLRECORD.value('(/row/c3[@m="3"]/text())[1]', 'nvarchar(10)') as Currency,
XMLRECORD.value('(/row/c6[@m="3"]/text())[1]', 'nvarchar(10)') as [MidRevealRate_CCY_Market-CASH],
XMLRECORD.value('(/row/c8[@m="3"]/text())[1]', 'nvarchar(10)') as [BuyRate_CCY_Market-IFT],
XMLRECORD.value('(/row/c8[@m="3"][@s="2"]/text())[1]', 'nvarchar(10)') as [BuyRate_CCY_Market-CASH],
XMLRECORD.value('(/row/c9[@m="3"]/text())[1]', 'nvarchar(10)') as [SellRate_CCY_Market-CASH]
FROM [FBNK_PT_CURRENCY]
WHERE RECID in ('VU0010002')

UNION

SELECT 
RECID as Branch,
XMLRECORD.value('(/row/c2/text())[1]', 'nvarchar(10)') as UpdateDate,
XMLRECORD.value('(/row/c3[@m="4"]/text())[1]', 'nvarchar(10)') as Currency,
XMLRECORD.value('(/row/c6[@m="4"]/text())[1]', 'nvarchar(10)') as [MidRevealRate_CCY_Market-CASH],
XMLRECORD.value('(/row/c8[@m="4"]/text())[1]', 'nvarchar(10)') as [BuyRate_CCY_Market-IFT],
XMLRECORD.value('(/row/c8[@m="4"][@s="2"]/text())[1]', 'nvarchar(10)') as [BuyRate_CCY_Market-CASH],
XMLRECORD.value('(/row/c9[@m="4"]/text())[1]', 'nvarchar(10)') as [SellRate_CCY_Market-CASH]
FROM [FBNK_PT_CURRENCY]
WHERE RECID in ('VU0010002')


Branch
UpdateDate
Currency
MidRevealRate_CCY_Market-CASH
BuyRate_CCY_Market-IFT
BuyRate_CCY_Market-CASH
SellRate_CCY_Market-CASH


VU0010002
20181210
EUR
128.39
127.17
119.52
132.17

VU0010002
20181210
FJD
53.22
51.58
49.99
55.57

VU0010002
20181210
GBP
143.07
141.73
134.44
146.31
Branch	UpdateDate	Currency	MidRevealRate_CCY_Market-CASH	BuyRate_CCY_Market-IFT	BuyRate_CCY_Market-CASH	SellRate_CCY_Market-CASH
VU0010002	20181210	EUR	128.39	127.17	119.52	132.17
VU0010002	20181210	FJD	53.22	51.58	49.99	55.57
VU0010002	20181210	GBP	143.07	141.73	134.44	146.31