Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

XML Cross Apply ...

4 views

Skip to first unread message

WCM

unread,

Sep 7, 2009, 6:38:02 PM9/7/09

Sql Server 2005:

The following tsql works fine, but I need to know if it is documented
syntax.

My reason for asking: I thought that the "Apply" operator allows you to
invoke a table-valued function for each row returned by an outer table
expression. But in the following example, it appears that the reverse is
happening: the outer expression is being applied to each row returned by the
nodes() method.

In the following code 'noder' is a table that contains an xml column named
'theNode" - the nodes method is used to shred that column into several rows
for each record in the noder table.

Thanks in advance for your response ...

Bill

********************

SELECT rec, [fileName],
T.NetAmount.value('(../../../../TrackingNumber)[1]', 'nvarchar(20)') as
TrackingNumber,
T.NetAmount.value('(../../../../../TransactionDateCCYYMMDD)[1]',
'nvarchar(20)') as TransDate,

T.NetAmount.value('(../../../../../AddressDetails/ReceiverAddress/Addressee/Name)[1]', 'varchar(100)') as Recipient,

T.NetAmount.value('(../../../../../AddressDetails/ReceiverAddress/Attention/Name)[1]', 'varchar(100)') as Recipient2,

T.NetAmount.value('(../../../../../AddressDetails/ReceiverAddress/Address/StreetAddress)[1]', 'varchar(100)') as Addr,

T.NetAmount.value('(../../../../../AddressDetails/ReceiverAddress/Address/CityName)[1]', 'varchar(100)') as City,

T.NetAmount.value('(../../../../../AddressDetails/ReceiverAddress/Address/StateCode)[1]', 'varchar(100)') as State,

T.NetAmount.value('(../../../../../AddressDetails/ReceiverAddress/Address/PostalCode)[1]', 'varchar(100)') as PostCode,
T.NetAmount.value('.', 'decimal(10,4)') AS NetAmount
into xmlT
FROM noder
cross apply
noder.theNode.nodes('Shipment/Package/ChargeDetails/Charge/ChargeInformation/NetAmount')
AS T(NetAmount);

**************************

Bob

unread,

Sep 8, 2009, 10:24:01 AM9/8/09

You should avoid excessive use of the parent axis (..) as documented here:

http://blogs.technet.com/wardpond/archive/2006/02/19/database-programming-applying-apply-solving-parent-axis-access-performance-issues-in-xml-access-in-sql-server-2005.aspx

Try something like this:

SELECT
rec,
[fileName],
Shipment.col.value('(Package/TrackingNumber)[1]', 'nvarchar(20)') AS
TrackingNumber,
Shipment.col.value('(TransactionDateCCYYMMDD)[1]', 'nvarchar(20)') AS
TransDate,
ReceiverAddress.col.value('(Addressee/Name)[1]', 'varchar(100)') AS
Recipient,
ReceiverAddress.col.value('(Attention/Name)[1]', 'varchar(100)') AS
Recipient2,
ReceiverAddress.col.value('(Address/StreetAddress)[1]', 'varchar(100)') AS
Addr,
ReceiverAddress.col.value('(Address/CityName)[1]', 'varchar(100)') AS City,
ReceiverAddress.col.value('(Address/StateCode)[1]', 'varchar(100)') AS State,
ReceiverAddress.col.value('(Address/PostalCode)[1]', 'varchar(100)') AS
PostCode,
NetAmount.col.value('.', 'DECIMAL(10,4)') AS NetAmount
--into xmlT
FROM noder
CROSS APPLY noder.theNode.nodes( 'Shipment' ) AS Shipment(col)
CROSS APPLY Shipment.col.nodes('AddressDetails/ReceiverAddress') AS
ReceiverAddress(col)
CROSS APPLY
Shipment.col.nodes('Package/ChargeDetails/Charge/ChargeInformation/NetAmount') AS NetAmount(col)

WCM

unread,

Sep 9, 2009, 3:17:17 PM9/9/09

Thank you, Bob - your answer (and also the link) are very helpful ... much
appreciated ...

Bill

Farmer

unread,

Sep 10, 2009, 8:39:12 AM9/10/09

Thanks Bob.
Your post made me think and research about axes travelling.

And here is a practical example that demonstrate how costly these can be.
This is from production logic I just did not so long ago and thanks to your
post I re-evaluated and fixed.

Two queries below take very different times to execute.
See for yourself.

THANK YOU.

-- http://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist-90d.xml
DECLARE @x 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="2009-09-09"><Cube
currency="USD" rate="1.4522"/><Cube currency="JPY" rate="134.13"/><Cube
currency="BGN" rate="1.9558"/><Cube currency="CZK" rate="25.522"/><Cube
currency="DKK" rate="7.4437"/><Cube currency="EEK" rate="15.6466"/><Cube
currency="GBP" rate="0.8793"/><Cube currency="HUF" rate="271.25"/><Cube
currency="LTL" rate="3.4528"/><Cube currency="LVL" rate="0.7024"/><Cube
currency="PLN" rate="4.124"/><Cube currency="RON" rate="4.2488"/><Cube
currency="SEK" rate="10.2308"/><Cube currency="CHF" rate="1.5173"/><Cube
currency="NOK" rate="8.611"/><Cube currency="HRK" rate="7.3457"/><Cube
currency="RUB" rate="45.2"/><Cube currency="TRY" rate="2.166"/><Cube
currency="AUD" rate="1.6836"/><Cube currency="BRL" rate="2.6497"/><Cube
currency="CAD" rate="1.569"/><Cube currency="CNY" rate="9.9168"/><Cube
currency="HKD" rate="11.255"/><Cube currency="IDR" rate="14411.86"/><Cube
currency="INR" rate="70.432"/><Cube currency="KRW" rate="1781.61"/><Cube
currency="MXN" rate="19.3687"/><Cube currency="MYR" rate="5.0776"/><Cube
currency="NZD" rate="2.0819"/><Cube currency="PHP" rate="70.297"/><Cube
currency="SGD" rate="2.0698"/><Cube currency="THB" rate="49.397"/><Cube
currency="ZAR" rate="10.9518"/></Cube>
<Cube time="2009-09-08"><Cube currency="USD" rate="1.4473"/><Cube
currency="JPY" rate="133.57"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.479"/><Cube currency="DKK" rate="7.4438"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.87365"/><Cube
currency="HUF" rate="270.98"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7021"/><Cube currency="PLN" rate="4.0893"/><Cube
currency="RON" rate="4.2412"/><Cube currency="SEK" rate="10.1867"/><Cube
currency="CHF" rate="1.5159"/><Cube currency="NOK" rate="8.569"/><Cube
currency="HRK" rate="7.3414"/><Cube currency="RUB" rate="45.37"/><Cube
currency="TRY" rate="2.1521"/><Cube currency="AUD" rate="1.677"/><Cube
currency="BRL" rate="2.6436"/><Cube currency="CAD" rate="1.5483"/><Cube
currency="CNY" rate="9.8814"/><Cube currency="HKD" rate="11.2169"/><Cube
currency="IDR" rate="14458.52"/><Cube currency="INR" rate="70.114"/><Cube
currency="KRW" rate="1783.31"/><Cube currency="MXN" rate="19.2419"/><Cube
currency="MYR" rate="5.0684"/><Cube currency="NZD" rate="2.079"/><Cube
currency="PHP" rate="69.979"/><Cube currency="SGD" rate="2.0644"/><Cube
currency="THB" rate="49.244"/><Cube currency="ZAR" rate="10.9076"/></Cube>
<Cube time="2009-09-07"><Cube currency="USD" rate="1.433"/><Cube
currency="JPY" rate="133.33"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.488"/><Cube currency="DKK" rate="7.4435"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8735"/><Cube
currency="HUF" rate="272.24"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.702"/><Cube currency="PLN" rate="4.11"/><Cube
currency="RON" rate="4.2463"/><Cube currency="SEK" rate="10.1955"/><Cube
currency="CHF" rate="1.5181"/><Cube currency="NOK" rate="8.585"/><Cube
currency="HRK" rate="7.3365"/><Cube currency="RUB" rate="45.1005"/><Cube
currency="TRY" rate="2.1374"/><Cube currency="AUD" rate="1.6748"/><Cube
currency="BRL" rate="2.6419"/><Cube currency="CAD" rate="1.5429"/><Cube
currency="CNY" rate="9.786"/><Cube currency="HKD" rate="11.1064"/><Cube
currency="IDR" rate="14417.23"/><Cube currency="INR" rate="69.73"/><Cube
currency="KRW" rate="1768.23"/><Cube currency="MXN" rate="19.1843"/><Cube
currency="MYR" rate="5.037"/><Cube currency="NZD" rate="2.0696"/><Cube
currency="PHP" rate="69.677"/><Cube currency="SGD" rate="2.0536"/><Cube
currency="THB" rate="48.784"/><Cube currency="ZAR" rate="10.87"/></Cube>
<Cube time="2009-09-04"><Cube currency="USD" rate="1.4262"/><Cube
currency="JPY" rate="132.45"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.561"/><Cube currency="DKK" rate="7.4436"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.872"/><Cube
currency="HUF" rate="274.35"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7023"/><Cube currency="PLN" rate="4.1145"/><Cube
currency="RON" rate="4.2468"/><Cube currency="SEK" rate="10.2844"/><Cube
currency="CHF" rate="1.5157"/><Cube currency="NOK" rate="8.608"/><Cube
currency="HRK" rate="7.3334"/><Cube currency="RUB" rate="45.1308"/><Cube
currency="TRY" rate="2.142"/><Cube currency="AUD" rate="1.6915"/><Cube
currency="BRL" rate="2.6469"/><Cube currency="CAD" rate="1.5581"/><Cube
currency="CNY" rate="9.7409"/><Cube currency="HKD" rate="11.0533"/><Cube
currency="IDR" rate="14426.36"/><Cube currency="INR" rate="69.727"/><Cube
currency="KRW" rate="1769.09"/><Cube currency="MXN" rate="19.3072"/><Cube
currency="MYR" rate="5.0281"/><Cube currency="NZD" rate="2.0851"/><Cube
currency="PHP" rate="69.337"/><Cube currency="SGD" rate="2.0517"/><Cube
currency="THB" rate="48.597"/><Cube currency="ZAR" rate="10.9136"/></Cube>
<Cube time="2009-09-03"><Cube currency="USD" rate="1.4335"/><Cube
currency="JPY" rate="132.47"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.615"/><Cube currency="DKK" rate="7.4438"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8747"/><Cube
currency="HUF" rate="273.95"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7027"/><Cube currency="PLN" rate="4.121"/><Cube
currency="RON" rate="4.2405"/><Cube currency="SEK" rate="10.3138"/><Cube
currency="CHF" rate="1.5143"/><Cube currency="NOK" rate="8.62"/><Cube
currency="HRK" rate="7.3455"/><Cube currency="RUB" rate="45.34"/><Cube
currency="TRY" rate="2.1549"/><Cube currency="AUD" rate="1.7037"/><Cube
currency="BRL" rate="2.678"/><Cube currency="CAD" rate="1.5742"/><Cube
currency="CNY" rate="9.7915"/><Cube currency="HKD" rate="11.1108"/><Cube
currency="IDR" rate="14493.04"/><Cube currency="INR" rate="70.12"/><Cube
currency="KRW" rate="1784.75"/><Cube currency="MXN" rate="19.412"/><Cube
currency="MYR" rate="5.0574"/><Cube currency="NZD" rate="2.1025"/><Cube
currency="PHP" rate="69.824"/><Cube currency="SGD" rate="2.062"/><Cube
currency="THB" rate="48.817"/><Cube currency="ZAR" rate="11.1046"/></Cube>
<Cube time="2009-09-02"><Cube currency="USD" rate="1.422"/><Cube
currency="JPY" rate="131.63"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.686"/><Cube currency="DKK" rate="7.4428"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8751"/><Cube
currency="HUF" rate="276.37"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7028"/><Cube currency="PLN" rate="4.168"/><Cube
currency="RON" rate="4.2388"/><Cube currency="SEK" rate="10.3186"/><Cube
currency="CHF" rate="1.5167"/><Cube currency="NOK" rate="8.68"/><Cube
currency="HRK" rate="7.3461"/><Cube currency="RUB" rate="45.3921"/><Cube
currency="TRY" rate="2.1512"/><Cube currency="AUD" rate="1.7112"/><Cube
currency="BRL" rate="2.7048"/><Cube currency="CAD" rate="1.572"/><Cube
currency="CNY" rate="9.7137"/><Cube currency="HKD" rate="11.0222"/><Cube
currency="IDR" rate="14450.56"/><Cube currency="INR" rate="69.642"/><Cube
currency="KRW" rate="1774.54"/><Cube currency="MXN" rate="19.3961"/><Cube
currency="MYR" rate="5.0332"/><Cube currency="NZD" rate="2.1078"/><Cube
currency="PHP" rate="69.534"/><Cube currency="SGD" rate="2.0526"/><Cube
currency="THB" rate="48.426"/><Cube currency="ZAR" rate="11.1879"/></Cube>
<Cube time="2009-09-01"><Cube currency="USD" rate="1.4314"/><Cube
currency="JPY" rate="133.26"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.567"/><Cube currency="DKK" rate="7.4432"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8815"/><Cube
currency="HUF" rate="273.65"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.703"/><Cube currency="PLN" rate="4.1088"/><Cube
currency="RON" rate="4.2278"/><Cube currency="SEK" rate="10.22"/><Cube
currency="CHF" rate="1.5153"/><Cube currency="NOK" rate="8.612"/><Cube
currency="HRK" rate="7.35"/><Cube currency="RUB" rate="45.5685"/><Cube
currency="TRY" rate="2.1558"/><Cube currency="AUD" rate="1.7096"/><Cube
currency="BRL" rate="2.6914"/><Cube currency="CAD" rate="1.5672"/><Cube
currency="CNY" rate="9.777"/><Cube currency="HKD" rate="11.0939"/><Cube
currency="IDR" rate="14477.49"/><Cube currency="INR" rate="70.139"/><Cube
currency="KRW" rate="1776.87"/><Cube currency="MXN" rate="19.2344"/><Cube
currency="MYR" rate="5.0485"/><Cube currency="NZD" rate="2.0953"/><Cube
currency="PHP" rate="69.773"/><Cube currency="SGD" rate="2.0644"/><Cube
currency="THB" rate="48.685"/><Cube currency="ZAR" rate="11.1649"/></Cube>
<Cube time="2009-08-31"><Cube currency="USD" rate="1.4272"/><Cube
currency="JPY" rate="133.1"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.376"/><Cube currency="DKK" rate="7.4431"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.88135"/><Cube
currency="HUF" rate="271.85"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7031"/><Cube currency="PLN" rate="4.104"/><Cube
currency="RON" rate="4.2238"/><Cube currency="SEK" rate="10.2191"/><Cube
currency="CHF" rate="1.5168"/><Cube currency="NOK" rate="8.607"/><Cube
currency="HRK" rate="7.364"/><Cube currency="RUB" rate="45.4645"/><Cube
currency="TRY" rate="2.148"/><Cube currency="AUD" rate="1.7087"/><Cube
currency="BRL" rate="2.7089"/><Cube currency="CAD" rate="1.5793"/><Cube
currency="CNY" rate="9.7486"/><Cube currency="HKD" rate="11.062"/><Cube
currency="IDR" rate="14390.15"/><Cube currency="INR" rate="69.79"/><Cube
currency="KRW" rate="1783.28"/><Cube currency="MXN" rate="19.0246"/><Cube
currency="MYR" rate="5.0259"/><Cube currency="NZD" rate="2.0973"/><Cube
currency="PHP" rate="69.667"/><Cube currency="SGD" rate="2.0602"/><Cube
currency="THB" rate="48.532"/><Cube currency="ZAR" rate="11.1136"/></Cube>
<Cube time="2009-08-28"><Cube currency="USD" rate="1.4364"/><Cube
currency="JPY" rate="134.75"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.42"/><Cube currency="DKK" rate="7.4432"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8784"/><Cube
currency="HUF" rate="270.74"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7035"/><Cube currency="PLN" rate="4.087"/><Cube
currency="RON" rate="4.217"/><Cube currency="SEK" rate="10.148"/><Cube
currency="CHF" rate="1.517"/><Cube currency="NOK" rate="8.629"/><Cube
currency="HRK" rate="7.358"/><Cube currency="RUB" rate="45.3466"/><Cube
currency="TRY" rate="2.1532"/><Cube currency="AUD" rate="1.6995"/><Cube
currency="BRL" rate="2.6731"/><Cube currency="CAD" rate="1.5522"/><Cube
currency="CNY" rate="9.8108"/><Cube currency="HKD" rate="11.1335"/><Cube
currency="IDR" rate="14435.32"/><Cube currency="INR" rate="69.895"/><Cube
currency="KRW" rate="1786.57"/><Cube currency="MXN" rate="19.0179"/><Cube
currency="MYR" rate="5.0583"/><Cube currency="NZD" rate="2.0908"/><Cube
currency="PHP" rate="70.092"/><Cube currency="SGD" rate="2.0672"/><Cube
currency="THB" rate="48.861"/><Cube currency="ZAR" rate="11.1376"/></Cube>
<Cube time="2009-08-27"><Cube currency="USD" rate="1.4268"/><Cube
currency="JPY" rate="133.61"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.406"/><Cube currency="DKK" rate="7.4436"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8804"/><Cube
currency="HUF" rate="268.5"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7035"/><Cube currency="PLN" rate="4.1125"/><Cube
currency="RON" rate="4.223"/><Cube currency="SEK" rate="10.1615"/><Cube
currency="CHF" rate="1.5234"/><Cube currency="NOK" rate="8.644"/><Cube
currency="HRK" rate="7.323"/><Cube currency="RUB" rate="45.1935"/><Cube
currency="TRY" rate="2.1431"/><Cube currency="AUD" rate="1.7101"/><Cube
currency="BRL" rate="2.6493"/><Cube currency="CAD" rate="1.5598"/><Cube
currency="CNY" rate="9.7479"/><Cube currency="HKD" rate="11.059"/><Cube
currency="IDR" rate="14506.97"/><Cube currency="INR" rate="69.792"/><Cube
currency="KRW" rate="1780.15"/><Cube currency="MXN" rate="18.753"/><Cube
currency="MYR" rate="5.0416"/><Cube currency="NZD" rate="2.0902"/><Cube
currency="PHP" rate="69.734"/><Cube currency="SGD" rate="2.0598"/><Cube
currency="THB" rate="48.547"/><Cube currency="ZAR" rate="11.202"/></Cube>
<Cube time="2009-08-26"><Cube currency="USD" rate="1.427"/><Cube
currency="JPY" rate="134.32"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.4"/><Cube currency="DKK" rate="7.4425"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.878"/><Cube
currency="HUF" rate="267.7"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.702"/><Cube currency="PLN" rate="4.0933"/><Cube
currency="RON" rate="4.221"/><Cube currency="SEK" rate="10.1445"/><Cube
currency="CHF" rate="1.5189"/><Cube currency="NOK" rate="8.624"/><Cube
currency="HRK" rate="7.32"/><Cube currency="RUB" rate="44.9315"/><Cube
currency="TRY" rate="2.1472"/><Cube currency="AUD" rate="1.7163"/><Cube
currency="BRL" rate="2.6619"/><Cube currency="CAD" rate="1.557"/><Cube
currency="CNY" rate="9.748"/><Cube currency="HKD" rate="11.0601"/><Cube
currency="IDR" rate="14406.62"/><Cube currency="INR" rate="69.773"/><Cube
currency="KRW" rate="1779.74"/><Cube currency="MXN" rate="18.5867"/><Cube
currency="MYR" rate="5.0287"/><Cube currency="NZD" rate="2.0879"/><Cube
currency="PHP" rate="69.543"/><Cube currency="SGD" rate="2.0597"/><Cube
currency="THB" rate="48.525"/><Cube currency="ZAR" rate="11.2092"/></Cube>
<Cube time="2009-08-25"><Cube currency="USD" rate="1.4324"/><Cube
currency="JPY" rate="135.05"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.356"/><Cube currency="DKK" rate="7.4429"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.87405"/><Cube
currency="HUF" rate="266.96"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6998"/><Cube currency="PLN" rate="4.0806"/><Cube
currency="RON" rate="4.221"/><Cube currency="SEK" rate="10.0895"/><Cube
currency="CHF" rate="1.5171"/><Cube currency="NOK" rate="8.6095"/><Cube
currency="HRK" rate="7.3203"/><Cube currency="RUB" rate="44.9399"/><Cube
currency="TRY" rate="2.1351"/><Cube currency="AUD" rate="1.7054"/><Cube
currency="BRL" rate="2.6293"/><Cube currency="CAD" rate="1.5411"/><Cube
currency="CNY" rate="9.7859"/><Cube currency="HKD" rate="11.1015"/><Cube
currency="IDR" rate="14359.3"/><Cube currency="INR" rate="69.837"/><Cube
currency="KRW" rate="1786.44"/><Cube currency="MXN" rate="18.4851"/><Cube
currency="MYR" rate="5.0413"/><Cube currency="NZD" rate="2.0832"/><Cube
currency="PHP" rate="69.3"/><Cube currency="SGD" rate="2.0655"/><Cube
currency="THB" rate="48.723"/><Cube currency="ZAR" rate="11.1739"/></Cube>
<Cube time="2009-08-24"><Cube currency="USD" rate="1.4323"/><Cube
currency="JPY" rate="135.57"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.44"/><Cube currency="DKK" rate="7.4431"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8682"/><Cube
currency="HUF" rate="268.15"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7005"/><Cube currency="PLN" rate="4.1123"/><Cube
currency="RON" rate="4.222"/><Cube currency="SEK" rate="10.1046"/><Cube
currency="CHF" rate="1.5184"/><Cube currency="NOK" rate="8.5845"/><Cube
currency="HRK" rate="7.3228"/><Cube currency="RUB" rate="45.041"/><Cube
currency="TRY" rate="2.1261"/><Cube currency="AUD" rate="1.7032"/><Cube
currency="BRL" rate="2.6168"/><Cube currency="CAD" rate="1.5444"/><Cube
currency="CNY" rate="9.7845"/><Cube currency="HKD" rate="11.1013"/><Cube
currency="IDR" rate="14331.16"/><Cube currency="INR" rate="69.631"/><Cube
currency="KRW" rate="1778.25"/><Cube currency="MXN" rate="18.3342"/><Cube
currency="MYR" rate="5.0267"/><Cube currency="NZD" rate="2.0865"/><Cube
currency="PHP" rate="69.28"/><Cube currency="SGD" rate="2.0633"/><Cube
currency="THB" rate="48.713"/><Cube currency="ZAR" rate="11.1195"/></Cube>
<Cube time="2009-08-21"><Cube currency="USD" rate="1.433"/><Cube
currency="JPY" rate="134.19"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.482"/><Cube currency="DKK" rate="7.4435"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8657"/><Cube
currency="HUF" rate="268.59"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6998"/><Cube currency="PLN" rate="4.1068"/><Cube
currency="RON" rate="4.224"/><Cube currency="SEK" rate="10.1432"/><Cube
currency="CHF" rate="1.516"/><Cube currency="NOK" rate="8.555"/><Cube
currency="HRK" rate="7.3083"/><Cube currency="RUB" rate="45.39"/><Cube
currency="TRY" rate="2.1324"/><Cube currency="AUD" rate="1.7197"/><Cube
currency="BRL" rate="2.6289"/><Cube currency="CAD" rate="1.5541"/><Cube
currency="CNY" rate="9.7891"/><Cube currency="HKD" rate="11.1074"/><Cube
currency="IDR" rate="14352.49"/><Cube currency="INR" rate="69.687"/><Cube
currency="KRW" rate="1788.62"/><Cube currency="MXN" rate="18.3954"/><Cube
currency="MYR" rate="5.0456"/><Cube currency="NZD" rate="2.1015"/><Cube
currency="PHP" rate="69.378"/><Cube currency="SGD" rate="2.062"/><Cube
currency="THB" rate="48.765"/><Cube currency="ZAR" rate="11.2261"/></Cube>
<Cube time="2009-08-20"><Cube currency="USD" rate="1.4243"/><Cube
currency="JPY" rate="134.11"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.585"/><Cube currency="DKK" rate="7.4436"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8638"/><Cube
currency="HUF" rate="271.5"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6993"/><Cube currency="PLN" rate="4.152"/><Cube
currency="RON" rate="4.2335"/><Cube currency="SEK" rate="10.1977"/><Cube
currency="CHF" rate="1.5169"/><Cube currency="NOK" rate="8.5955"/><Cube
currency="HRK" rate="7.332"/><Cube currency="RUB" rate="45.22"/><Cube
currency="TRY" rate="2.125"/><Cube currency="AUD" rate="1.7124"/><Cube
currency="BRL" rate="2.6194"/><Cube currency="CAD" rate="1.56"/><Cube
currency="CNY" rate="9.7305"/><Cube currency="HKD" rate="11.0398"/><Cube
currency="IDR" rate="14326.89"/><Cube currency="INR" rate="69.371"/><Cube
currency="KRW" rate="1777.5"/><Cube currency="MXN" rate="18.2733"/><Cube
currency="MYR" rate="5.0228"/><Cube currency="NZD" rate="2.1055"/><Cube
currency="PHP" rate="68.964"/><Cube currency="SGD" rate="2.0617"/><Cube
currency="THB" rate="48.462"/><Cube currency="ZAR" rate="11.3161"/></Cube>
<Cube time="2009-08-19"><Cube currency="USD" rate="1.4112"/><Cube
currency="JPY" rate="132.55"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.711"/><Cube currency="DKK" rate="7.4433"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8608"/><Cube
currency="HUF" rate="274.41"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7003"/><Cube currency="PLN" rate="4.1935"/><Cube
currency="RON" rate="4.2288"/><Cube currency="SEK" rate="10.2585"/><Cube
currency="CHF" rate="1.5152"/><Cube currency="NOK" rate="8.67"/><Cube
currency="HRK" rate="7.3185"/><Cube currency="RUB" rate="45.056"/><Cube
currency="TRY" rate="2.1285"/><Cube currency="AUD" rate="1.7239"/><Cube
currency="BRL" rate="2.6237"/><Cube currency="CAD" rate="1.5657"/><Cube
currency="CNY" rate="9.6443"/><Cube currency="HKD" rate="10.9397"/><Cube
currency="IDR" rate="14296.39"/><Cube currency="INR" rate="68.86"/><Cube
currency="KRW" rate="1775.37"/><Cube currency="MXN" rate="18.3202"/><Cube
currency="MYR" rate="5.0048"/><Cube currency="NZD" rate="2.1108"/><Cube
currency="PHP" rate="68.442"/><Cube currency="SGD" rate="2.0494"/><Cube
currency="THB" rate="48.058"/><Cube currency="ZAR" rate="11.424"/></Cube>
<Cube time="2009-08-18"><Cube currency="USD" rate="1.4101"/><Cube
currency="JPY" rate="134.12"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.568"/><Cube currency="DKK" rate="7.4433"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8566"/><Cube
currency="HUF" rate="272.66"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7002"/><Cube currency="PLN" rate="4.1645"/><Cube
currency="RON" rate="4.2188"/><Cube currency="SEK" rate="10.2375"/><Cube
currency="CHF" rate="1.5207"/><Cube currency="NOK" rate="8.6735"/><Cube
currency="HRK" rate="7.3093"/><Cube currency="RUB" rate="45.105"/><Cube
currency="TRY" rate="2.1117"/><Cube currency="AUD" rate="1.7116"/><Cube
currency="BRL" rate="2.6281"/><Cube currency="CAD" rate="1.5606"/><Cube
currency="CNY" rate="9.6365"/><Cube currency="HKD" rate="10.9302"/><Cube
currency="IDR" rate="14133"/><Cube currency="INR" rate="68.806"/><Cube
currency="KRW" rate="1762.49"/><Cube currency="MXN" rate="18.2467"/><Cube
currency="MYR" rate="4.9882"/><Cube currency="NZD" rate="2.0985"/><Cube
currency="PHP" rate="68.047"/><Cube currency="SGD" rate="2.045"/><Cube
currency="THB" rate="48.021"/><Cube currency="ZAR" rate="11.345"/></Cube>
<Cube time="2009-08-17"><Cube currency="USD" rate="1.4072"/><Cube
currency="JPY" rate="132.94"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.785"/><Cube currency="DKK" rate="7.4435"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8629"/><Cube
currency="HUF" rate="274.07"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.198"/><Cube
currency="RON" rate="4.2245"/><Cube currency="SEK" rate="10.288"/><Cube
currency="CHF" rate="1.5212"/><Cube currency="NOK" rate="8.7265"/><Cube
currency="HRK" rate="7.3027"/><Cube currency="RUB" rate="45.48"/><Cube
currency="TRY" rate="2.1222"/><Cube currency="AUD" rate="1.7208"/><Cube
currency="BRL" rate="2.6396"/><Cube currency="CAD" rate="1.5621"/><Cube
currency="CNY" rate="9.6203"/><Cube currency="HKD" rate="10.9068"/><Cube
currency="IDR" rate="14119.06"/><Cube currency="INR" rate="68.812"/><Cube
currency="KRW" rate="1771.04"/><Cube currency="MXN" rate="18.3075"/><Cube
currency="MYR" rate="4.985"/><Cube currency="NZD" rate="2.1155"/><Cube
currency="PHP" rate="68.076"/><Cube currency="SGD" rate="2.0434"/><Cube
currency="THB" rate="47.95"/><Cube currency="ZAR" rate="11.5338"/></Cube>
<Cube time="2009-08-14"><Cube currency="USD" rate="1.4294"/><Cube
currency="JPY" rate="135.61"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.733"/><Cube currency="DKK" rate="7.4444"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8616"/><Cube
currency="HUF" rate="269.2"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.124"/><Cube
currency="RON" rate="4.213"/><Cube currency="SEK" rate="10.1835"/><Cube
currency="CHF" rate="1.5267"/><Cube currency="NOK" rate="8.6165"/><Cube
currency="HRK" rate="7.312"/><Cube currency="RUB" rate="45.12"/><Cube
currency="TRY" rate="2.116"/><Cube currency="AUD" rate="1.6939"/><Cube
currency="BRL" rate="2.602"/><Cube currency="CAD" rate="1.5509"/><Cube
currency="CNY" rate="9.7688"/><Cube currency="HKD" rate="11.0784"/><Cube
currency="IDR" rate="14246.96"/><Cube currency="INR" rate="68.961"/><Cube
currency="KRW" rate="1769.06"/><Cube currency="MXN" rate="18.3544"/><Cube
currency="MYR" rate="5.0279"/><Cube currency="NZD" rate="2.0785"/><Cube
currency="PHP" rate="68.695"/><Cube currency="SGD" rate="2.0628"/><Cube
currency="THB" rate="48.635"/><Cube currency="ZAR" rate="11.5152"/></Cube>
<Cube time="2009-08-13"><Cube currency="USD" rate="1.4293"/><Cube
currency="JPY" rate="137.52"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.738"/><Cube currency="DKK" rate="7.4447"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85865"/><Cube
currency="HUF" rate="268.21"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7008"/><Cube currency="PLN" rate="4.1085"/><Cube
currency="RON" rate="4.215"/><Cube currency="SEK" rate="10.196"/><Cube
currency="CHF" rate="1.5328"/><Cube currency="NOK" rate="8.608"/><Cube
currency="HRK" rate="7.3245"/><Cube currency="RUB" rate="45.412"/><Cube
currency="TRY" rate="2.1056"/><Cube currency="AUD" rate="1.6931"/><Cube
currency="BRL" rate="2.6029"/><Cube currency="CAD" rate="1.5451"/><Cube
currency="CNY" rate="9.7674"/><Cube currency="HKD" rate="11.0786"/><Cube
currency="IDR" rate="14225.1"/><Cube currency="INR" rate="68.692"/><Cube
currency="KRW" rate="1759.41"/><Cube currency="MXN" rate="18.3544"/><Cube
currency="MYR" rate="5.0147"/><Cube currency="NZD" rate="2.1021"/><Cube
currency="PHP" rate="68.495"/><Cube currency="SGD" rate="2.0599"/><Cube
currency="THB" rate="48.664"/><Cube currency="ZAR" rate="11.369"/></Cube>
<Cube time="2009-08-12"><Cube currency="USD" rate="1.417"/><Cube
currency="JPY" rate="135.77"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.768"/><Cube currency="DKK" rate="7.4445"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85965"/><Cube
currency="HUF" rate="273.6"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.701"/><Cube currency="PLN" rate="4.1813"/><Cube
currency="RON" rate="4.2218"/><Cube currency="SEK" rate="10.2656"/><Cube
currency="CHF" rate="1.5276"/><Cube currency="NOK" rate="8.7325"/><Cube
currency="HRK" rate="7.3259"/><Cube currency="RUB" rate="46.09"/><Cube
currency="TRY" rate="2.1267"/><Cube currency="AUD" rate="1.7201"/><Cube
currency="BRL" rate="2.6176"/><Cube currency="CAD" rate="1.5633"/><Cube
currency="CNY" rate="9.6853"/><Cube currency="HKD" rate="10.9828"/><Cube
currency="IDR" rate="14162.71"/><Cube currency="INR" rate="68.533"/><Cube
currency="KRW" rate="1767.31"/><Cube currency="MXN" rate="18.52"/><Cube
currency="MYR" rate="5.0027"/><Cube currency="NZD" rate="2.1294"/><Cube
currency="PHP" rate="68.102"/><Cube currency="SGD" rate="2.0509"/><Cube
currency="THB" rate="48.277"/><Cube currency="ZAR" rate="11.5202"/></Cube>
<Cube time="2009-08-11"><Cube currency="USD" rate="1.4166"/><Cube
currency="JPY" rate="136.72"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.77"/><Cube currency="DKK" rate="7.4449"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8584"/><Cube
currency="HUF" rate="273.1"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7011"/><Cube currency="PLN" rate="4.174"/><Cube
currency="RON" rate="4.2163"/><Cube currency="SEK" rate="10.3486"/><Cube
currency="CHF" rate="1.5301"/><Cube currency="NOK" rate="8.8265"/><Cube
currency="HRK" rate="7.3224"/><Cube currency="RUB" rate="45.769"/><Cube
currency="TRY" rate="2.1225"/><Cube currency="AUD" rate="1.6965"/><Cube
currency="BRL" rate="2.6277"/><Cube currency="CAD" rate="1.5537"/><Cube
currency="CNY" rate="9.6825"/><Cube currency="HKD" rate="10.9793"/><Cube
currency="IDR" rate="14054.16"/><Cube currency="INR" rate="67.94"/><Cube
currency="KRW" rate="1759.28"/><Cube currency="MXN" rate="18.3946"/><Cube
currency="MYR" rate="4.973"/><Cube currency="NZD" rate="2.1126"/><Cube
currency="PHP" rate="67.596"/><Cube currency="SGD" rate="2.0489"/><Cube
currency="THB" rate="48.228"/><Cube currency="ZAR" rate="11.5304"/></Cube>
<Cube time="2009-08-10"><Cube currency="USD" rate="1.4202"/><Cube
currency="JPY" rate="138.01"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.678"/><Cube currency="DKK" rate="7.445"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85355"/><Cube
currency="HUF" rate="269.31"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7006"/><Cube currency="PLN" rate="4.1154"/><Cube
currency="RON" rate="4.2095"/><Cube currency="SEK" rate="10.2129"/><Cube
currency="CHF" rate="1.5345"/><Cube currency="NOK" rate="8.694"/><Cube
currency="HRK" rate="7.3269"/><Cube currency="RUB" rate="45.0035"/><Cube
currency="TRY" rate="2.0929"/><Cube currency="AUD" rate="1.6895"/><Cube
currency="BRL" rate="2.5813"/><Cube currency="CAD" rate="1.5361"/><Cube
currency="CNY" rate="9.7062"/><Cube currency="HKD" rate="11.007"/><Cube
currency="IDR" rate="14103.4"/><Cube currency="INR" rate="67.9"/><Cube
currency="KRW" rate="1742.67"/><Cube currency="MXN" rate="18.3135"/><Cube
currency="MYR" rate="4.9771"/><Cube currency="NZD" rate="2.0985"/><Cube
currency="PHP" rate="67.729"/><Cube currency="SGD" rate="2.0468"/><Cube
currency="THB" rate="48.322"/><Cube currency="ZAR" rate="11.4031"/></Cube>
<Cube time="2009-08-07"><Cube currency="USD" rate="1.4357"/><Cube
currency="JPY" rate="136.89"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.91"/><Cube currency="DKK" rate="7.4448"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8567"/><Cube
currency="HUF" rate="272.8"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7023"/><Cube currency="PLN" rate="4.167"/><Cube
currency="RON" rate="4.2168"/><Cube currency="SEK" rate="10.3008"/><Cube
currency="CHF" rate="1.5288"/><Cube currency="NOK" rate="8.7515"/><Cube
currency="HRK" rate="7.335"/><Cube currency="RUB" rate="45.445"/><Cube
currency="TRY" rate="2.13"/><Cube currency="AUD" rate="1.7161"/><Cube
currency="BRL" rate="2.6336"/><Cube currency="CAD" rate="1.554"/><Cube
currency="CNY" rate="9.8084"/><Cube currency="HKD" rate="11.1272"/><Cube
currency="IDR" rate="14308.44"/><Cube currency="INR" rate="68.576"/><Cube
currency="KRW" rate="1761.67"/><Cube currency="MXN" rate="18.7072"/><Cube
currency="MYR" rate="5.0257"/><Cube currency="NZD" rate="2.1315"/><Cube
currency="PHP" rate="68.557"/><Cube currency="SGD" rate="2.0628"/><Cube
currency="THB" rate="48.778"/><Cube currency="ZAR" rate="11.6875"/></Cube>
<Cube time="2009-08-06"><Cube currency="USD" rate="1.437"/><Cube
currency="JPY" rate="137.31"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.944"/><Cube currency="DKK" rate="7.445"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8524"/><Cube
currency="HUF" rate="269.89"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7025"/><Cube currency="PLN" rate="4.145"/><Cube
currency="RON" rate="4.2121"/><Cube currency="SEK" rate="10.2707"/><Cube
currency="CHF" rate="1.529"/><Cube currency="NOK" rate="8.6635"/><Cube
currency="HRK" rate="7.3359"/><Cube currency="RUB" rate="44.951"/><Cube
currency="TRY" rate="2.122"/><Cube currency="AUD" rate="1.7067"/><Cube
currency="BRL" rate="2.6129"/><Cube currency="CAD" rate="1.5416"/><Cube
currency="CNY" rate="9.8164"/><Cube currency="HKD" rate="11.1369"/><Cube
currency="IDR" rate="14275.85"/><Cube currency="INR" rate="68.401"/><Cube
currency="KRW" rate="1759.06"/><Cube currency="MXN" rate="18.711"/><Cube
currency="MYR" rate="5.0158"/><Cube currency="NZD" rate="2.1435"/><Cube
currency="PHP" rate="68.626"/><Cube currency="SGD" rate="2.0632"/><Cube
currency="THB" rate="48.833"/><Cube currency="ZAR" rate="11.585"/></Cube>
<Cube time="2009-08-05"><Cube currency="USD" rate="1.441"/><Cube
currency="JPY" rate="137.38"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.945"/><Cube currency="DKK" rate="7.445"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84695"/><Cube
currency="HUF" rate="267"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7028"/><Cube currency="PLN" rate="4.1005"/><Cube
currency="RON" rate="4.2045"/><Cube currency="SEK" rate="10.2683"/><Cube
currency="CHF" rate="1.5316"/><Cube currency="NOK" rate="8.6685"/><Cube
currency="HRK" rate="7.3383"/><Cube currency="RUB" rate="44.8946"/><Cube
currency="TRY" rate="2.1019"/><Cube currency="AUD" rate="1.708"/><Cube
currency="BRL" rate="2.6141"/><Cube currency="CAD" rate="1.5507"/><Cube
currency="CNY" rate="9.8433"/><Cube currency="HKD" rate="11.1678"/><Cube
currency="IDR" rate="14279.88"/><Cube currency="INR" rate="68.332"/><Cube
currency="KRW" rate="1762.11"/><Cube currency="MXN" rate="18.9082"/><Cube
currency="MYR" rate="5.0399"/><Cube currency="NZD" rate="2.1347"/><Cube
currency="PHP" rate="68.976"/><Cube currency="SGD" rate="2.0653"/><Cube
currency="THB" rate="48.98"/><Cube currency="ZAR" rate="11.3966"/></Cube>
<Cube time="2009-08-04"><Cube currency="USD" rate="1.4384"/><Cube
currency="JPY" rate="136.22"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.863"/><Cube currency="DKK" rate="7.4452"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84845"/><Cube
currency="HUF" rate="267.05"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7025"/><Cube currency="PLN" rate="4.1233"/><Cube
currency="RON" rate="4.2145"/><Cube currency="SEK" rate="10.3043"/><Cube
currency="CHF" rate="1.5286"/><Cube currency="NOK" rate="8.704"/><Cube
currency="HRK" rate="7.347"/><Cube currency="RUB" rate="44.842"/><Cube
currency="TRY" rate="2.1091"/><Cube currency="AUD" rate="1.7116"/><Cube
currency="BRL" rate="2.6393"/><Cube currency="CAD" rate="1.5369"/><Cube
currency="CNY" rate="9.8246"/><Cube currency="HKD" rate="11.1477"/><Cube
currency="IDR" rate="14208.64"/><Cube currency="INR" rate="68.439"/><Cube
currency="KRW" rate="1753.18"/><Cube currency="MXN" rate="18.9279"/><Cube
currency="MYR" rate="5.0265"/><Cube currency="NZD" rate="2.1609"/><Cube
currency="PHP" rate="68.824"/><Cube currency="SGD" rate="2.0622"/><Cube
currency="THB" rate="48.884"/><Cube currency="ZAR" rate="11.2817"/></Cube>
<Cube time="2009-08-03"><Cube currency="USD" rate="1.4303"/><Cube
currency="JPY" rate="135.86"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.695"/><Cube currency="DKK" rate="7.4449"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8492"/><Cube
currency="HUF" rate="265.7"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7023"/><Cube currency="PLN" rate="4.1088"/><Cube
currency="RON" rate="4.203"/><Cube currency="SEK" rate="10.2983"/><Cube
currency="CHF" rate="1.5246"/><Cube currency="NOK" rate="8.68"/><Cube
currency="HRK" rate="7.356"/><Cube currency="RUB" rate="44.4465"/><Cube
currency="TRY" rate="2.0956"/><Cube currency="AUD" rate="1.702"/><Cube
currency="BRL" rate="2.6482"/><Cube currency="CAD" rate="1.5274"/><Cube
currency="CNY" rate="9.7701"/><Cube currency="HKD" rate="11.0849"/><Cube
currency="IDR" rate="14163.96"/><Cube currency="INR" rate="68.068"/><Cube
currency="KRW" rate="1745.63"/><Cube currency="MXN" rate="18.7627"/><Cube
currency="MYR" rate="5.0168"/><Cube currency="NZD" rate="2.1445"/><Cube
currency="PHP" rate="68.742"/><Cube currency="SGD" rate="2.0513"/><Cube
currency="THB" rate="48.652"/><Cube currency="ZAR" rate="11.0823"/></Cube>
<Cube time="2009-07-31"><Cube currency="USD" rate="1.4138"/><Cube
currency="JPY" rate="135.33"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.573"/><Cube currency="DKK" rate="7.4461"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8556"/><Cube
currency="HUF" rate="266.53"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7023"/><Cube currency="PLN" rate="4.159"/><Cube
currency="RON" rate="4.2185"/><Cube currency="SEK" rate="10.3358"/><Cube
currency="CHF" rate="1.5317"/><Cube currency="NOK" rate="8.715"/><Cube
currency="HRK" rate="7.3523"/><Cube currency="RUB" rate="44.54"/><Cube
currency="TRY" rate="2.087"/><Cube currency="AUD" rate="1.706"/><Cube
currency="BRL" rate="2.6482"/><Cube currency="CAD" rate="1.5234"/><Cube
currency="CNY" rate="9.6592"/><Cube currency="HKD" rate="10.957"/><Cube
currency="IDR" rate="14068.37"/><Cube currency="INR" rate="67.95"/><Cube
currency="KRW" rate="1728.71"/><Cube currency="MXN" rate="18.6678"/><Cube
currency="MYR" rate="4.9801"/><Cube currency="NZD" rate="2.1578"/><Cube
currency="PHP" rate="67.941"/><Cube currency="SGD" rate="2.0377"/><Cube
currency="THB" rate="48.112"/><Cube currency="ZAR" rate="11.0368"/></Cube>
<Cube time="2009-07-30"><Cube currency="USD" rate="1.4053"/><Cube
currency="JPY" rate="133.89"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.581"/><Cube currency="DKK" rate="7.4453"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8524"/><Cube
currency="HUF" rate="268.31"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7014"/><Cube currency="PLN" rate="4.1775"/><Cube
currency="RON" rate="4.207"/><Cube currency="SEK" rate="10.4515"/><Cube
currency="CHF" rate="1.5314"/><Cube currency="NOK" rate="8.749"/><Cube
currency="HRK" rate="7.3615"/><Cube currency="RUB" rate="44.506"/><Cube
currency="TRY" rate="2.0861"/><Cube currency="AUD" rate="1.7042"/><Cube
currency="BRL" rate="2.6495"/><Cube currency="CAD" rate="1.524"/><Cube
currency="CNY" rate="9.6014"/><Cube currency="HKD" rate="10.8911"/><Cube
currency="IDR" rate="13989.56"/><Cube currency="INR" rate="67.89"/><Cube
currency="KRW" rate="1735.5"/><Cube currency="MXN" rate="18.6483"/><Cube
currency="MYR" rate="4.9628"/><Cube currency="NZD" rate="2.1555"/><Cube
currency="PHP" rate="67.602"/><Cube currency="SGD" rate="2.0296"/><Cube
currency="THB" rate="47.857"/><Cube currency="ZAR" rate="11.0079"/></Cube>
<Cube time="2009-07-29"><Cube currency="USD" rate="1.4104"/><Cube
currency="JPY" rate="133.86"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.54"/><Cube currency="DKK" rate="7.4451"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8611"/><Cube
currency="HUF" rate="269.75"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.702"/><Cube currency="PLN" rate="4.1928"/><Cube
currency="RON" rate="4.2183"/><Cube currency="SEK" rate="10.5849"/><Cube
currency="CHF" rate="1.5268"/><Cube currency="NOK" rate="8.789"/><Cube
currency="HRK" rate="7.342"/><Cube currency="RUB" rate="44.217"/><Cube
currency="TRY" rate="2.0975"/><Cube currency="AUD" rate="1.722"/><Cube
currency="BRL" rate="2.6679"/><Cube currency="CAD" rate="1.5335"/><Cube
currency="CNY" rate="9.635"/><Cube currency="HKD" rate="10.9307"/><Cube
currency="IDR" rate="14043.96"/><Cube currency="INR" rate="68.3"/><Cube
currency="KRW" rate="1752.15"/><Cube currency="MXN" rate="18.716"/><Cube
currency="MYR" rate="4.9836"/><Cube currency="NZD" rate="2.1457"/><Cube
currency="PHP" rate="67.859"/><Cube currency="SGD" rate="2.0353"/><Cube
currency="THB" rate="47.989"/><Cube currency="ZAR" rate="11.1778"/></Cube>
<Cube time="2009-07-28"><Cube currency="USD" rate="1.4229"/><Cube
currency="JPY" rate="134.53"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.501"/><Cube currency="DKK" rate="7.4453"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8622"/><Cube
currency="HUF" rate="267.55"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7012"/><Cube currency="PLN" rate="4.1765"/><Cube
currency="RON" rate="4.205"/><Cube currency="SEK" rate="10.585"/><Cube
currency="CHF" rate="1.5224"/><Cube currency="NOK" rate="8.766"/><Cube
currency="HRK" rate="7.333"/><Cube currency="RUB" rate="43.8914"/><Cube
currency="TRY" rate="2.0992"/><Cube currency="AUD" rate="1.7138"/><Cube
currency="BRL" rate="2.6697"/><Cube currency="CAD" rate="1.5378"/><Cube
currency="CNY" rate="9.7197"/><Cube currency="HKD" rate="11.0287"/><Cube
currency="IDR" rate="14121.19"/><Cube currency="INR" rate="68.605"/><Cube
currency="KRW" rate="1762.97"/><Cube currency="MXN" rate="18.8641"/><Cube
currency="MYR" rate="4.9937"/><Cube currency="NZD" rate="2.1531"/><Cube
currency="PHP" rate="68.334"/><Cube currency="SGD" rate="2.0497"/><Cube
currency="THB" rate="48.3"/><Cube currency="ZAR" rate="11.1131"/></Cube>
<Cube time="2009-07-27"><Cube currency="USD" rate="1.4269"/><Cube
currency="JPY" rate="135.61"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.517"/><Cube currency="DKK" rate="7.4449"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8653"/><Cube
currency="HUF" rate="268"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7024"/><Cube currency="PLN" rate="4.1761"/><Cube
currency="RON" rate="4.2075"/><Cube currency="SEK" rate="10.5265"/><Cube
currency="CHF" rate="1.5237"/><Cube currency="NOK" rate="8.801"/><Cube
currency="HRK" rate="7.327"/><Cube currency="RUB" rate="43.8435"/><Cube
currency="TRY" rate="2.1122"/><Cube currency="AUD" rate="1.7331"/><Cube
currency="BRL" rate="2.695"/><Cube currency="CAD" rate="1.5433"/><Cube
currency="CNY" rate="9.7472"/><Cube currency="HKD" rate="11.0586"/><Cube
currency="IDR" rate="14222.2"/><Cube currency="INR" rate="68.727"/><Cube
currency="KRW" rate="1772.48"/><Cube currency="MXN" rate="18.7709"/><Cube
currency="MYR" rate="5.0205"/><Cube currency="NZD" rate="2.1697"/><Cube
currency="PHP" rate="68.535"/><Cube currency="SGD" rate="2.0545"/><Cube
currency="THB" rate="48.465"/><Cube currency="ZAR" rate="11.0541"/></Cube>
<Cube time="2009-07-24"><Cube currency="USD" rate="1.4227"/><Cube
currency="JPY" rate="134.92"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.472"/><Cube currency="DKK" rate="7.4447"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.867"/><Cube
currency="HUF" rate="266.59"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.703"/><Cube currency="PLN" rate="4.188"/><Cube
currency="RON" rate="4.215"/><Cube currency="SEK" rate="10.5995"/><Cube
currency="CHF" rate="1.5217"/><Cube currency="NOK" rate="8.86"/><Cube
currency="HRK" rate="7.332"/><Cube currency="RUB" rate="44.099"/><Cube
currency="TRY" rate="2.11"/><Cube currency="AUD" rate="1.7413"/><Cube
currency="BRL" rate="2.6904"/><Cube currency="CAD" rate="1.5407"/><Cube
currency="CNY" rate="9.7185"/><Cube currency="HKD" rate="11.0259"/><Cube
currency="IDR" rate="14226.34"/><Cube currency="INR" rate="68.617"/><Cube
currency="KRW" rate="1775.37"/><Cube currency="MXN" rate="18.7555"/><Cube
currency="MYR" rate="5.0214"/><Cube currency="NZD" rate="2.1663"/><Cube
currency="PHP" rate="68.387"/><Cube currency="SGD" rate="2.0487"/><Cube
currency="THB" rate="48.322"/><Cube currency="ZAR" rate="11.0494"/></Cube>
<Cube time="2009-07-23"><Cube currency="USD" rate="1.4229"/><Cube
currency="JPY" rate="134.23"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.625"/><Cube currency="DKK" rate="7.4452"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8617"/><Cube
currency="HUF" rate="271.26"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.703"/><Cube currency="PLN" rate="4.25"/><Cube
currency="RON" rate="4.235"/><Cube currency="SEK" rate="10.7567"/><Cube
currency="CHF" rate="1.5203"/><Cube currency="NOK" rate="8.925"/><Cube
currency="HRK" rate="7.319"/><Cube currency="RUB" rate="44.361"/><Cube
currency="TRY" rate="2.118"/><Cube currency="AUD" rate="1.7376"/><Cube
currency="BRL" rate="2.6957"/><Cube currency="CAD" rate="1.5606"/><Cube
currency="CNY" rate="9.7198"/><Cube currency="HKD" rate="11.0275"/><Cube
currency="IDR" rate="14268.07"/><Cube currency="INR" rate="68.94"/><Cube
currency="KRW" rate="1779.06"/><Cube currency="MXN" rate="18.7681"/><Cube
currency="MYR" rate="5.0371"/><Cube currency="NZD" rate="2.1579"/><Cube
currency="PHP" rate="68.426"/><Cube currency="SGD" rate="2.0504"/><Cube
currency="THB" rate="48.357"/><Cube currency="ZAR" rate="10.9471"/></Cube>
<Cube time="2009-07-22"><Cube currency="USD" rate="1.4191"/><Cube
currency="JPY" rate="132.49"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.825"/><Cube currency="DKK" rate="7.4458"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8648"/><Cube
currency="HUF" rate="271.55"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.702"/><Cube currency="PLN" rate="4.2548"/><Cube
currency="RON" rate="4.2348"/><Cube currency="SEK" rate="10.8073"/><Cube
currency="CHF" rate="1.5164"/><Cube currency="NOK" rate="8.92"/><Cube
currency="HRK" rate="7.3362"/><Cube currency="RUB" rate="44.2661"/><Cube
currency="TRY" rate="2.1247"/><Cube currency="AUD" rate="1.7455"/><Cube
currency="BRL" rate="2.6989"/><Cube currency="CAD" rate="1.5704"/><Cube
currency="CNY" rate="9.6933"/><Cube currency="HKD" rate="10.998"/><Cube
currency="IDR" rate="14316.74"/><Cube currency="INR" rate="68.855"/><Cube
currency="KRW" rate="1777.34"/><Cube currency="MXN" rate="18.8286"/><Cube
currency="MYR" rate="5.0421"/><Cube currency="NZD" rate="2.1657"/><Cube
currency="PHP" rate="68.065"/><Cube currency="SGD" rate="2.048"/><Cube
currency="THB" rate="48.271"/><Cube currency="ZAR" rate="11.0069"/></Cube>
<Cube time="2009-07-21"><Cube currency="USD" rate="1.4223"/><Cube
currency="JPY" rate="134.1"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.815"/><Cube currency="DKK" rate="7.4464"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8653"/><Cube
currency="HUF" rate="271.3"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7005"/><Cube currency="PLN" rate="4.2525"/><Cube
currency="RON" rate="4.2368"/><Cube currency="SEK" rate="10.8925"/><Cube
currency="CHF" rate="1.5186"/><Cube currency="NOK" rate="8.9515"/><Cube
currency="HRK" rate="7.334"/><Cube currency="RUB" rate="44.11"/><Cube
currency="TRY" rate="2.136"/><Cube currency="AUD" rate="1.7438"/><Cube
currency="BRL" rate="2.701"/><Cube currency="CAD" rate="1.5689"/><Cube
currency="CNY" rate="9.7153"/><Cube currency="HKD" rate="11.0229"/><Cube
currency="IDR" rate="14301.78"/><Cube currency="INR" rate="68.896"/><Cube
currency="KRW" rate="1774.19"/><Cube currency="MXN" rate="18.8597"/><Cube
currency="MYR" rate="5.0378"/><Cube currency="NZD" rate="2.1647"/><Cube
currency="PHP" rate="68.161"/><Cube currency="SGD" rate="2.0491"/><Cube
currency="THB" rate="48.351"/><Cube currency="ZAR" rate="11.1587"/></Cube>
<Cube time="2009-07-20"><Cube currency="USD" rate="1.4217"/><Cube
currency="JPY" rate="134.44"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.838"/><Cube currency="DKK" rate="7.4462"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8601"/><Cube
currency="HUF" rate="272.9"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7004"/><Cube currency="PLN" rate="4.298"/><Cube
currency="RON" rate="4.239"/><Cube currency="SEK" rate="11.0023"/><Cube
currency="CHF" rate="1.5198"/><Cube currency="NOK" rate="9.0085"/><Cube
currency="HRK" rate="7.3352"/><Cube currency="RUB" rate="43.98"/><Cube
currency="TRY" rate="2.1476"/><Cube currency="AUD" rate="1.751"/><Cube
currency="BRL" rate="2.7122"/><Cube currency="CAD" rate="1.5702"/><Cube
currency="CNY" rate="9.7118"/><Cube currency="HKD" rate="11.0184"/><Cube
currency="IDR" rate="14202.88"/><Cube currency="INR" rate="68.533"/><Cube
currency="KRW" rate="1772.41"/><Cube currency="MXN" rate="18.7878"/><Cube
currency="MYR" rate="5.035"/><Cube currency="NZD" rate="2.1714"/><Cube
currency="PHP" rate="68.141"/><Cube currency="SGD" rate="2.0489"/><Cube
currency="THB" rate="48.359"/><Cube currency="ZAR" rate="11.2989"/></Cube>
<Cube time="2009-07-17"><Cube currency="USD" rate="1.409"/><Cube
currency="JPY" rate="132.06"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.918"/><Cube currency="DKK" rate="7.4453"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8653"/><Cube
currency="HUF" rate="274.2"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.3355"/><Cube
currency="RON" rate="4.2475"/><Cube currency="SEK" rate="11.0476"/><Cube
currency="CHF" rate="1.5193"/><Cube currency="NOK" rate="8.996"/><Cube
currency="HRK" rate="7.336"/><Cube currency="RUB" rate="44.801"/><Cube
currency="TRY" rate="2.1525"/><Cube currency="AUD" rate="1.7621"/><Cube
currency="BRL" rate="2.7293"/><Cube currency="CAD" rate="1.5734"/><Cube
currency="CNY" rate="9.6259"/><Cube currency="HKD" rate="10.9198"/><Cube
currency="IDR" rate="14340.05"/><Cube currency="INR" rate="68.661"/><Cube
currency="KRW" rate="1780.6"/><Cube currency="MXN" rate="19.1765"/><Cube
currency="MYR" rate="5.0238"/><Cube currency="NZD" rate="2.1884"/><Cube
currency="PHP" rate="67.567"/><Cube currency="SGD" rate="2.0438"/><Cube
currency="THB" rate="47.991"/><Cube currency="ZAR" rate="11.414"/></Cube>
<Cube time="2009-07-16"><Cube currency="USD" rate="1.413"/><Cube
currency="JPY" rate="132.63"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.861"/><Cube currency="DKK" rate="7.4456"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8591"/><Cube
currency="HUF" rate="272.82"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7005"/><Cube currency="PLN" rate="4.29"/><Cube
currency="RON" rate="4.2313"/><Cube currency="SEK" rate="11.0135"/><Cube
currency="CHF" rate="1.5154"/><Cube currency="NOK" rate="9.0015"/><Cube
currency="HRK" rate="7.327"/><Cube currency="RUB" rate="44.9351"/><Cube
currency="TRY" rate="2.157"/><Cube currency="AUD" rate="1.7582"/><Cube
currency="BRL" rate="2.7279"/><Cube currency="CAD" rate="1.5787"/><Cube
currency="CNY" rate="9.6526"/><Cube currency="HKD" rate="10.9512"/><Cube
currency="IDR" rate="14305.53"/><Cube currency="INR" rate="68.771"/><Cube
currency="KRW" rate="1795.45"/><Cube currency="MXN" rate="19.1829"/><Cube
currency="MYR" rate="5.0465"/><Cube currency="NZD" rate="2.1852"/><Cube
currency="PHP" rate="67.739"/><Cube currency="SGD" rate="2.0501"/><Cube
currency="THB" rate="48.13"/><Cube currency="ZAR" rate="11.4575"/></Cube>
<Cube time="2009-07-15"><Cube currency="USD" rate="1.4089"/><Cube
currency="JPY" rate="131.57"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.9"/><Cube currency="DKK" rate="7.4453"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8576"/><Cube
currency="HUF" rate="273.25"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7004"/><Cube currency="PLN" rate="4.29"/><Cube
currency="RON" rate="4.2165"/><Cube currency="SEK" rate="10.9746"/><Cube
currency="CHF" rate="1.5179"/><Cube currency="NOK" rate="9.019"/><Cube
currency="HRK" rate="7.324"/><Cube currency="RUB" rate="44.9035"/><Cube
currency="TRY" rate="2.1625"/><Cube currency="AUD" rate="1.7551"/><Cube
currency="BRL" rate="2.7472"/><Cube currency="CAD" rate="1.5813"/><Cube
currency="CNY" rate="9.625"/><Cube currency="HKD" rate="10.9194"/><Cube
currency="IDR" rate="14275.68"/><Cube currency="INR" rate="68.515"/><Cube
currency="KRW" rate="1797.93"/><Cube currency="MXN" rate="19.2836"/><Cube
currency="MYR" rate="5.0206"/><Cube currency="NZD" rate="2.178"/><Cube
currency="PHP" rate="67.5"/><Cube currency="SGD" rate="2.046"/><Cube
currency="THB" rate="48.01"/><Cube currency="ZAR" rate="11.4842"/></Cube>
<Cube time="2009-07-14"><Cube currency="USD" rate="1.3991"/><Cube
currency="JPY" rate="130.34"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.014"/><Cube currency="DKK" rate="7.4458"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85755"/><Cube
currency="HUF" rate="275.79"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7012"/><Cube currency="PLN" rate="4.3557"/><Cube
currency="RON" rate="4.2165"/><Cube currency="SEK" rate="10.9725"/><Cube
currency="CHF" rate="1.5159"/><Cube currency="NOK" rate="9.0355"/><Cube
currency="HRK" rate="7.332"/><Cube currency="RUB" rate="45.189"/><Cube
currency="TRY" rate="2.154"/><Cube currency="AUD" rate="1.7689"/><Cube
currency="BRL" rate="2.7537"/><Cube currency="CAD" rate="1.6018"/><Cube
currency="CNY" rate="9.5599"/><Cube currency="HKD" rate="10.8436"/><Cube
currency="IDR" rate="14284.31"/><Cube currency="INR" rate="68.507"/><Cube
currency="KRW" rate="1815.93"/><Cube currency="MXN" rate="19.1327"/><Cube
currency="MYR" rate="5.0179"/><Cube currency="NZD" rate="2.1988"/><Cube
currency="PHP" rate="67.362"/><Cube currency="SGD" rate="2.0404"/><Cube
currency="THB" rate="47.758"/><Cube currency="ZAR" rate="11.4694"/></Cube>
<Cube time="2009-07-13"><Cube currency="USD" rate="1.3975"/><Cube
currency="JPY" rate="129.03"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.028"/><Cube currency="DKK" rate="7.4451"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8678"/><Cube
currency="HUF" rate="277.96"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.402"/><Cube
currency="RON" rate="4.2238"/><Cube currency="SEK" rate="11.0518"/><Cube
currency="CHF" rate="1.5133"/><Cube currency="NOK" rate="9.07"/><Cube
currency="HRK" rate="7.331"/><Cube currency="RUB" rate="45.89"/><Cube
currency="TRY" rate="2.1701"/><Cube currency="AUD" rate="1.801"/><Cube
currency="BRL" rate="2.785"/><Cube currency="CAD" rate="1.6239"/><Cube
currency="CNY" rate="9.5487"/><Cube currency="HKD" rate="10.8308"/><Cube
currency="IDR" rate="14310.09"/><Cube currency="INR" rate="68.603"/><Cube
currency="KRW" rate="1831.85"/><Cube currency="MXN" rate="19.1576"/><Cube
currency="MYR" rate="5.0338"/><Cube currency="NZD" rate="2.2407"/><Cube
currency="PHP" rate="67.508"/><Cube currency="SGD" rate="2.0483"/><Cube
currency="THB" rate="47.732"/><Cube currency="ZAR" rate="11.5835"/></Cube>
<Cube time="2009-07-10"><Cube currency="USD" rate="1.3901"/><Cube
currency="JPY" rate="128.21"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.03"/><Cube currency="DKK" rate="7.4466"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.858"/><Cube
currency="HUF" rate="277.5"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6993"/><Cube currency="PLN" rate="4.374"/><Cube
currency="RON" rate="4.216"/><Cube currency="SEK" rate="11.0022"/><Cube
currency="CHF" rate="1.514"/><Cube currency="NOK" rate="9.084"/><Cube
currency="HRK" rate="7.3315"/><Cube currency="RUB" rate="45.4005"/><Cube
currency="TRY" rate="2.1636"/><Cube currency="AUD" rate="1.794"/><Cube
currency="BRL" rate="2.8084"/><Cube currency="CAD" rate="1.6212"/><Cube
currency="CNY" rate="9.4983"/><Cube currency="HKD" rate="10.7736"/><Cube
currency="IDR" rate="14174.11"/><Cube currency="INR" rate="67.823"/><Cube
currency="KRW" rate="1786.89"/><Cube currency="MXN" rate="19.0303"/><Cube
currency="MYR" rate="4.9731"/><Cube currency="NZD" rate="2.225"/><Cube
currency="PHP" rate="67.026"/><Cube currency="SGD" rate="2.0331"/><Cube
currency="THB" rate="47.382"/><Cube currency="ZAR" rate="11.4023"/></Cube>
<Cube time="2009-07-09"><Cube currency="USD" rate="1.399"/><Cube
currency="JPY" rate="130.05"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.933"/><Cube currency="DKK" rate="7.4469"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8606"/><Cube
currency="HUF" rate="275"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6997"/><Cube currency="PLN" rate="4.3548"/><Cube
currency="RON" rate="4.2142"/><Cube currency="SEK" rate="10.9785"/><Cube
currency="CHF" rate="1.5119"/><Cube currency="NOK" rate="9.074"/><Cube
currency="HRK" rate="7.345"/><Cube currency="RUB" rate="44.52"/><Cube
currency="TRY" rate="2.1625"/><Cube currency="AUD" rate="1.7831"/><Cube
currency="BRL" rate="2.8025"/><Cube currency="CAD" rate="1.6182"/><Cube
currency="CNY" rate="9.5575"/><Cube currency="HKD" rate="10.8426"/><Cube
currency="IDR" rate="14193.23"/><Cube currency="INR" rate="68.145"/><Cube
currency="KRW" rate="1787.29"/><Cube currency="MXN" rate="18.8424"/><Cube
currency="MYR" rate="4.986"/><Cube currency="NZD" rate="2.2194"/><Cube
currency="PHP" rate="67.306"/><Cube currency="SGD" rate="2.0408"/><Cube
currency="THB" rate="47.669"/><Cube currency="ZAR" rate="11.333"/></Cube>
<Cube time="2009-07-08"><Cube currency="USD" rate="1.3901"/><Cube
currency="JPY" rate="131.02"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.047"/><Cube currency="DKK" rate="7.4469"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.86495"/><Cube
currency="HUF" rate="278.1"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.4338"/><Cube
currency="RON" rate="4.2178"/><Cube currency="SEK" rate="11.06"/><Cube
currency="CHF" rate="1.5162"/><Cube currency="NOK" rate="9.077"/><Cube
currency="HRK" rate="7.343"/><Cube currency="RUB" rate="44.125"/><Cube
currency="TRY" rate="2.1623"/><Cube currency="AUD" rate="1.7728"/><Cube
currency="BRL" rate="2.7686"/><Cube currency="CAD" rate="1.6206"/><Cube
currency="CNY" rate="9.4984"/><Cube currency="HKD" rate="10.7738"/><Cube
currency="IDR" rate="14248.39"/><Cube currency="INR" rate="67.962"/><Cube
currency="KRW" rate="1776.14"/><Cube currency="MXN" rate="18.701"/><Cube
currency="MYR" rate="4.9522"/><Cube currency="NZD" rate="2.2168"/><Cube
currency="PHP" rate="67.049"/><Cube currency="SGD" rate="2.0323"/><Cube
currency="THB" rate="47.368"/><Cube currency="ZAR" rate="11.345"/></Cube>
<Cube time="2009-07-07"><Cube currency="USD" rate="1.4019"/><Cube
currency="JPY" rate="133.61"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.882"/><Cube currency="DKK" rate="7.4465"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8638"/><Cube
currency="HUF" rate="273.2"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6971"/><Cube currency="PLN" rate="4.374"/><Cube
currency="RON" rate="4.2117"/><Cube currency="SEK" rate="10.965"/><Cube
currency="CHF" rate="1.5181"/><Cube currency="NOK" rate="9.0565"/><Cube
currency="HRK" rate="7.3425"/><Cube currency="RUB" rate="44.0625"/><Cube
currency="TRY" rate="2.1593"/><Cube currency="AUD" rate="1.7484"/><Cube
currency="BRL" rate="2.7321"/><Cube currency="CAD" rate="1.6223"/><Cube
currency="CNY" rate="9.5788"/><Cube currency="HKD" rate="10.8648"/><Cube
currency="IDR" rate="14374.43"/><Cube currency="INR" rate="67.614"/><Cube
currency="KRW" rate="1784.41"/><Cube currency="MXN" rate="18.51"/><Cube
currency="MYR" rate="4.9746"/><Cube currency="NZD" rate="2.1996"/><Cube
currency="PHP" rate="67.591"/><Cube currency="SGD" rate="2.042"/><Cube
currency="THB" rate="47.794"/><Cube currency="ZAR" rate="11.1837"/></Cube>
<Cube time="2009-07-06"><Cube currency="USD" rate="1.3897"/><Cube
currency="JPY" rate="132.44"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.954"/><Cube currency="DKK" rate="7.4461"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8612"/><Cube
currency="HUF" rate="273.7"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6969"/><Cube currency="PLN" rate="4.387"/><Cube
currency="RON" rate="4.2083"/><Cube currency="SEK" rate="10.9205"/><Cube
currency="CHF" rate="1.5198"/><Cube currency="NOK" rate="9.054"/><Cube
currency="HRK" rate="7.3296"/><Cube currency="RUB" rate="43.811"/><Cube
currency="TRY" rate="2.154"/><Cube currency="AUD" rate="1.7605"/><Cube
currency="BRL" rate="2.7401"/><Cube currency="CAD" rate="1.6193"/><Cube
currency="CNY" rate="9.4979"/><Cube currency="HKD" rate="10.7704"/><Cube
currency="IDR" rate="14217.14"/><Cube currency="INR" rate="67.505"/><Cube
currency="KRW" rate="1762.78"/><Cube currency="MXN" rate="18.549"/><Cube
currency="MYR" rate="4.9265"/><Cube currency="NZD" rate="2.2175"/><Cube
currency="PHP" rate="67.069"/><Cube currency="SGD" rate="2.0265"/><Cube
currency="THB" rate="47.424"/><Cube currency="ZAR" rate="11.135"/></Cube>
<Cube time="2009-07-03"><Cube currency="USD" rate="1.4009"/><Cube
currency="JPY" rate="134.32"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.865"/><Cube currency="DKK" rate="7.4459"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85625"/><Cube
currency="HUF" rate="272.55"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6975"/><Cube currency="PLN" rate="4.3525"/><Cube
currency="RON" rate="4.2035"/><Cube currency="SEK" rate="10.9135"/><Cube
currency="CHF" rate="1.5228"/><Cube currency="NOK" rate="8.966"/><Cube
currency="HRK" rate="7.3208"/><Cube currency="RUB" rate="43.7877"/><Cube
currency="TRY" rate="2.148"/><Cube currency="AUD" rate="1.7552"/><Cube
currency="BRL" rate="2.7271"/><Cube currency="CAD" rate="1.6203"/><Cube
currency="CNY" rate="9.5714"/><Cube currency="HKD" rate="10.857"/><Cube
currency="IDR" rate="14274.83"/><Cube currency="INR" rate="67.075"/><Cube
currency="KRW" rate="1773.07"/><Cube currency="MXN" rate="18.5339"/><Cube
currency="MYR" rate="4.9403"/><Cube currency="NZD" rate="2.2119"/><Cube
currency="PHP" rate="67.282"/><Cube currency="SGD" rate="2.0352"/><Cube
currency="THB" rate="47.757"/><Cube currency="ZAR" rate="11.082"/></Cube>
<Cube time="2009-07-02"><Cube currency="USD" rate="1.4049"/><Cube
currency="JPY" rate="135.95"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.755"/><Cube currency="DKK" rate="7.446"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8573"/><Cube
currency="HUF" rate="268.45"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7005"/><Cube currency="PLN" rate="4.3543"/><Cube
currency="RON" rate="4.2062"/><Cube currency="SEK" rate="10.84"/><Cube
currency="CHF" rate="1.5235"/><Cube currency="NOK" rate="8.9375"/><Cube
currency="HRK" rate="7.2992"/><Cube currency="RUB" rate="43.8009"/><Cube
currency="TRY" rate="2.1489"/><Cube currency="AUD" rate="1.7525"/><Cube
currency="BRL" rate="2.7222"/><Cube currency="CAD" rate="1.6201"/><Cube
currency="CNY" rate="9.5974"/><Cube currency="HKD" rate="10.8879"/><Cube
currency="IDR" rate="14374.42"/><Cube currency="INR" rate="67.358"/><Cube
currency="KRW" rate="1783.8"/><Cube currency="MXN" rate="18.4393"/><Cube
currency="MYR" rate="4.9452"/><Cube currency="NZD" rate="2.2168"/><Cube
currency="PHP" rate="67.569"/><Cube currency="SGD" rate="2.0377"/><Cube
currency="THB" rate="47.9"/><Cube currency="ZAR" rate="10.9708"/></Cube>
<Cube time="2009-07-01"><Cube currency="USD" rate="1.4096"/><Cube
currency="JPY" rate="136.53"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.77"/><Cube currency="DKK" rate="7.4455"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8562"/><Cube
currency="HUF" rate="271.11"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7024"/><Cube currency="PLN" rate="4.3904"/><Cube
currency="RON" rate="4.1941"/><Cube currency="SEK" rate="10.72"/><Cube
currency="CHF" rate="1.5241"/><Cube currency="NOK" rate="8.98"/><Cube
currency="HRK" rate="7.2715"/><Cube currency="RUB" rate="43.887"/><Cube
currency="TRY" rate="2.1559"/><Cube currency="AUD" rate="1.7485"/><Cube
currency="BRL" rate="2.7367"/><Cube currency="CAD" rate="1.6224"/><Cube
currency="CNY" rate="9.6319"/><Cube currency="HKD" rate="10.9247"/><Cube
currency="IDR" rate="14421.33"/><Cube currency="INR" rate="67.513"/><Cube
currency="KRW" rate="1797.53"/><Cube currency="MXN" rate="18.5228"/><Cube
currency="MYR" rate="4.9604"/><Cube currency="NZD" rate="2.2017"/><Cube
currency="PHP" rate="67.623"/><Cube currency="SGD" rate="2.0393"/><Cube
currency="THB" rate="47.99"/><Cube currency="ZAR" rate="10.9048"/></Cube>
<Cube time="2009-06-30"><Cube currency="USD" rate="1.4134"/><Cube
currency="JPY" rate="135.51"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.882"/><Cube currency="DKK" rate="7.447"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8521"/><Cube
currency="HUF" rate="271.55"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7036"/><Cube currency="PLN" rate="4.452"/><Cube
currency="RON" rate="4.2072"/><Cube currency="SEK" rate="10.8125"/><Cube
currency="CHF" rate="1.5265"/><Cube currency="NOK" rate="9.018"/><Cube
currency="HRK" rate="7.273"/><Cube currency="RUB" rate="43.881"/><Cube
currency="TRY" rate="2.1614"/><Cube currency="AUD" rate="1.7359"/><Cube
currency="BRL" rate="2.7469"/><Cube currency="CAD" rate="1.6275"/><Cube
currency="CNY" rate="9.6545"/><Cube currency="HKD" rate="10.954"/><Cube
currency="IDR" rate="14427.58"/><Cube currency="INR" rate="67.518"/><Cube
currency="KRW" rate="1802.43"/><Cube currency="MXN" rate="18.5537"/><Cube
currency="MYR" rate="4.9681"/><Cube currency="NZD" rate="2.1656"/><Cube
currency="PHP" rate="67.865"/><Cube currency="SGD" rate="2.0441"/><Cube
currency="THB" rate="48.14"/><Cube currency="ZAR" rate="10.8853"/></Cube>
<Cube time="2009-06-29"><Cube currency="USD" rate="1.4058"/><Cube
currency="JPY" rate="134.03"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.02"/><Cube currency="DKK" rate="7.4463"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84865"/><Cube
currency="HUF" rate="276.21"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7007"/><Cube currency="PLN" rate="4.496"/><Cube
currency="RON" rate="4.2135"/><Cube currency="SEK" rate="10.8658"/><Cube
currency="CHF" rate="1.526"/><Cube currency="NOK" rate="9.034"/><Cube
currency="HRK" rate="7.2801"/><Cube currency="RUB" rate="43.8375"/><Cube
currency="TRY" rate="2.1619"/><Cube currency="AUD" rate="1.7451"/><Cube
currency="BRL" rate="2.7209"/><Cube currency="CAD" rate="1.6236"/><Cube
currency="CNY" rate="9.607"/><Cube currency="HKD" rate="10.8949"/><Cube
currency="IDR" rate="14435.59"/><Cube currency="INR" rate="67.549"/><Cube
currency="KRW" rate="1807.3"/><Cube currency="MXN" rate="18.5321"/><Cube
currency="MYR" rate="4.9758"/><Cube currency="NZD" rate="2.1673"/><Cube
currency="PHP" rate="67.783"/><Cube currency="SGD" rate="2.0444"/><Cube
currency="THB" rate="47.846"/><Cube currency="ZAR" rate="10.9867"/></Cube>
<Cube time="2009-06-26"><Cube currency="USD" rate="1.4096"/><Cube
currency="JPY" rate="134.5"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="25.998"/><Cube currency="DKK" rate="7.4464"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8543"/><Cube
currency="HUF" rate="275.3"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.699"/><Cube currency="PLN" rate="4.4945"/><Cube
currency="RON" rate="4.2174"/><Cube currency="SEK" rate="10.9595"/><Cube
currency="CHF" rate="1.5275"/><Cube currency="NOK" rate="9.04"/><Cube
currency="HRK" rate="7.286"/><Cube currency="RUB" rate="43.858"/><Cube
currency="TRY" rate="2.1645"/><Cube currency="AUD" rate="1.7457"/><Cube
currency="BRL" rate="2.721"/><Cube currency="CAD" rate="1.6168"/><Cube
currency="CNY" rate="9.6329"/><Cube currency="HKD" rate="10.9245"/><Cube
currency="IDR" rate="14407.13"/><Cube currency="INR" rate="67.802"/><Cube
currency="KRW" rate="1805.28"/><Cube currency="MXN" rate="18.5461"/><Cube
currency="MYR" rate="4.9794"/><Cube currency="NZD" rate="2.1795"/><Cube
currency="PHP" rate="67.921"/><Cube currency="SGD" rate="2.0493"/><Cube
currency="THB" rate="47.997"/><Cube currency="ZAR" rate="11.1439"/></Cube>
<Cube time="2009-06-25"><Cube currency="USD" rate="1.394"/><Cube
currency="JPY" rate="134.34"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.08"/><Cube currency="DKK" rate="7.4455"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8567"/><Cube
currency="HUF" rate="277.1"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6963"/><Cube currency="PLN" rate="4.516"/><Cube
currency="RON" rate="4.2232"/><Cube currency="SEK" rate="11.0718"/><Cube
currency="CHF" rate="1.5311"/><Cube currency="NOK" rate="9.076"/><Cube
currency="HRK" rate="7.3105"/><Cube currency="RUB" rate="43.54"/><Cube
currency="TRY" rate="2.1691"/><Cube currency="AUD" rate="1.7488"/><Cube
currency="BRL" rate="2.7368"/><Cube currency="CAD" rate="1.62"/><Cube
currency="CNY" rate="9.5276"/><Cube currency="HKD" rate="10.8037"/><Cube
currency="IDR" rate="14328.78"/><Cube currency="INR" rate="67.752"/><Cube
currency="KRW" rate="1794.95"/><Cube currency="MXN" rate="18.4593"/><Cube
currency="MYR" rate="4.9292"/><Cube currency="NZD" rate="2.187"/><Cube
currency="PHP" rate="67.111"/><Cube currency="SGD" rate="2.0336"/><Cube
currency="THB" rate="47.57"/><Cube currency="ZAR" rate="11.2586"/></Cube>
<Cube time="2009-06-24"><Cube currency="USD" rate="1.4029"/><Cube
currency="JPY" rate="133.77"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.16"/><Cube currency="DKK" rate="7.4447"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8493"/><Cube
currency="HUF" rate="277.75"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.697"/><Cube currency="PLN" rate="4.532"/><Cube
currency="RON" rate="4.2268"/><Cube currency="SEK" rate="11.026"/><Cube
currency="CHF" rate="1.5183"/><Cube currency="NOK" rate="9.009"/><Cube
currency="HRK" rate="7.3147"/><Cube currency="RUB" rate="43.8104"/><Cube
currency="TRY" rate="2.1829"/><Cube currency="AUD" rate="1.7566"/><Cube
currency="BRL" rate="2.7652"/><Cube currency="CAD" rate="1.6105"/><Cube
currency="CNY" rate="9.5857"/><Cube currency="HKD" rate="10.8725"/><Cube
currency="IDR" rate="14564.2"/><Cube currency="INR" rate="68.083"/><Cube
currency="KRW" rate="1799.18"/><Cube currency="MXN" rate="18.6351"/><Cube
currency="MYR" rate="4.9564"/><Cube currency="NZD" rate="2.1806"/><Cube
currency="PHP" rate="67.514"/><Cube currency="SGD" rate="2.0401"/><Cube
currency="THB" rate="47.888"/><Cube currency="ZAR" rate="11.2993"/></Cube>
<Cube time="2009-06-23"><Cube currency="USD" rate="1.3978"/><Cube
currency="JPY" rate="133.49"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.207"/><Cube currency="DKK" rate="7.4442"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.85735"/><Cube
currency="HUF" rate="281.2"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.697"/><Cube currency="PLN" rate="4.5462"/><Cube
currency="RON" rate="4.235"/><Cube currency="SEK" rate="11.1025"/><Cube
currency="CHF" rate="1.5031"/><Cube currency="NOK" rate="9.099"/><Cube
currency="HRK" rate="7.2725"/><Cube currency="RUB" rate="43.93"/><Cube
currency="TRY" rate="2.1944"/><Cube currency="AUD" rate="1.7744"/><Cube
currency="BRL" rate="2.8152"/><Cube currency="CAD" rate="1.6101"/><Cube
currency="CNY" rate="9.5537"/><Cube currency="HKD" rate="10.8331"/><Cube
currency="IDR" rate="14691.82"/><Cube currency="INR" rate="67.867"/><Cube
currency="KRW" rate="1799.72"/><Cube currency="MXN" rate="18.5385"/><Cube
currency="MYR" rate="4.958"/><Cube currency="NZD" rate="2.2046"/><Cube
currency="PHP" rate="67.5"/><Cube currency="SGD" rate="2.037"/><Cube
currency="THB" rate="47.742"/><Cube currency="ZAR" rate="11.4724"/></Cube>
<Cube time="2009-06-22"><Cube currency="USD" rate="1.3858"/><Cube
currency="JPY" rate="133.02"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.019"/><Cube currency="DKK" rate="7.4444"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84255"/><Cube
currency="HUF" rate="278.62"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.697"/><Cube currency="PLN" rate="4.523"/><Cube
currency="RON" rate="4.2203"/><Cube currency="SEK" rate="11.0785"/><Cube
currency="CHF" rate="1.5074"/><Cube currency="NOK" rate="8.986"/><Cube
currency="HRK" rate="7.2664"/><Cube currency="RUB" rate="43.41"/><Cube
currency="TRY" rate="2.1652"/><Cube currency="AUD" rate="1.742"/><Cube
currency="BRL" rate="2.7612"/><Cube currency="CAD" rate="1.5871"/><Cube
currency="CNY" rate="9.4728"/><Cube currency="HKD" rate="10.7404"/><Cube
currency="IDR" rate="14494.01"/><Cube currency="INR" rate="67.114"/><Cube
currency="KRW" rate="1771.4"/><Cube currency="MXN" rate="18.6446"/><Cube
currency="MYR" rate="4.9064"/><Cube currency="NZD" rate="2.1844"/><Cube
currency="PHP" rate="66.871"/><Cube currency="SGD" rate="2.0214"/><Cube
currency="THB" rate="47.335"/><Cube currency="ZAR" rate="11.2912"/></Cube>
<Cube time="2009-06-19"><Cube currency="USD" rate="1.3932"/><Cube
currency="JPY" rate="134.84"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.357"/><Cube currency="DKK" rate="7.4434"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.84715"/><Cube
currency="HUF" rate="279.5"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6975"/><Cube currency="PLN" rate="4.5138"/><Cube
currency="RON" rate="4.2143"/><Cube currency="SEK" rate="10.9725"/><Cube
currency="CHF" rate="1.5102"/><Cube currency="NOK" rate="8.8995"/><Cube
currency="HRK" rate="7.278"/><Cube currency="RUB" rate="43.4098"/><Cube
currency="TRY" rate="2.1642"/><Cube currency="AUD" rate="1.7283"/><Cube
currency="BRL" rate="2.7325"/><Cube currency="CAD" rate="1.5708"/><Cube
currency="CNY" rate="9.5242"/><Cube currency="HKD" rate="10.7976"/><Cube
currency="IDR" rate="14491"/><Cube currency="INR" rate="66.888"/><Cube
currency="KRW" rate="1761.36"/><Cube currency="MXN" rate="18.5714"/><Cube
currency="MYR" rate="4.9264"/><Cube currency="NZD" rate="2.1685"/><Cube
currency="PHP" rate="67.36"/><Cube currency="SGD" rate="2.0274"/><Cube
currency="THB" rate="47.585"/><Cube currency="ZAR" rate="11.291"/></Cube>
<Cube time="2009-06-18"><Cube currency="USD" rate="1.392"/><Cube
currency="JPY" rate="133.57"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.645"/><Cube currency="DKK" rate="7.444"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8583"/><Cube
currency="HUF" rate="283.57"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.698"/><Cube currency="PLN" rate="4.5575"/><Cube
currency="RON" rate="4.2319"/><Cube currency="SEK" rate="10.966"/><Cube
currency="CHF" rate="1.5013"/><Cube currency="NOK" rate="8.8825"/><Cube
currency="HRK" rate="7.292"/><Cube currency="RUB" rate="43.4455"/><Cube
currency="TRY" rate="2.1822"/><Cube currency="AUD" rate="1.7528"/><Cube
currency="BRL" rate="2.7519"/><Cube currency="CAD" rate="1.5758"/><Cube
currency="CNY" rate="9.5139"/><Cube currency="HKD" rate="10.7885"/><Cube
currency="IDR" rate="14310.78"/><Cube currency="INR" rate="66.969"/><Cube
currency="KRW" rate="1761.44"/><Cube currency="MXN" rate="18.6946"/><Cube
currency="MYR" rate="4.9284"/><Cube currency="NZD" rate="2.1923"/><Cube
currency="PHP" rate="67.322"/><Cube currency="SGD" rate="2.0292"/><Cube
currency="THB" rate="47.533"/><Cube currency="ZAR" rate="11.348"/></Cube>
<Cube time="2009-06-17"><Cube currency="USD" rate="1.384"/><Cube
currency="JPY" rate="133.28"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.695"/><Cube currency="DKK" rate="7.4447"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8522"/><Cube
currency="HUF" rate="283.8"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6985"/><Cube currency="PLN" rate="4.5283"/><Cube
currency="RON" rate="4.2323"/><Cube currency="SEK" rate="10.8932"/><Cube
currency="CHF" rate="1.5096"/><Cube currency="NOK" rate="8.918"/><Cube
currency="HRK" rate="7.278"/><Cube currency="RUB" rate="43.324"/><Cube
currency="TRY" rate="2.1575"/><Cube currency="AUD" rate="1.7528"/><Cube
currency="BRL" rate="2.7427"/><Cube currency="CAD" rate="1.5794"/><Cube
currency="CNY" rate="9.463"/><Cube currency="HKD" rate="10.7263"/><Cube
currency="IDR" rate="14223.55"/><Cube currency="INR" rate="66.418"/><Cube
currency="KRW" rate="1737.55"/><Cube currency="MXN" rate="18.6785"/><Cube
currency="MYR" rate="4.8904"/><Cube currency="NZD" rate="2.2077"/><Cube
currency="PHP" rate="66.845"/><Cube currency="SGD" rate="2.0196"/><Cube
currency="THB" rate="47.302"/><Cube currency="ZAR" rate="11.1715"/></Cube>
<Cube time="2009-06-16"><Cube currency="USD" rate="1.389"/><Cube
currency="JPY" rate="134.78"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.773"/><Cube currency="DKK" rate="7.4446"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8437"/><Cube
currency="HUF" rate="280.08"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7"/><Cube currency="PLN" rate="4.5305"/><Cube
currency="RON" rate="4.2338"/><Cube currency="SEK" rate="10.8595"/><Cube
currency="CHF" rate="1.507"/><Cube currency="NOK" rate="8.917"/><Cube
currency="HRK" rate="7.2676"/><Cube currency="RUB" rate="43.2647"/><Cube
currency="TRY" rate="2.1435"/><Cube currency="AUD" rate="1.7324"/><Cube
currency="BRL" rate="2.6887"/><Cube currency="CAD" rate="1.5612"/><Cube
currency="CNY" rate="9.4926"/><Cube currency="HKD" rate="10.765"/><Cube
currency="IDR" rate="14202.52"/><Cube currency="INR" rate="66.116"/><Cube
currency="KRW" rate="1742.77"/><Cube currency="MXN" rate="18.5015"/><Cube
currency="MYR" rate="4.8893"/><Cube currency="NZD" rate="2.1809"/><Cube
currency="PHP" rate="66.921"/><Cube currency="SGD" rate="2.0233"/><Cube
currency="THB" rate="47.372"/><Cube currency="ZAR" rate="11.1064"/></Cube>
<Cube time="2009-06-15"><Cube currency="USD" rate="1.385"/><Cube
currency="JPY" rate="136.08"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.839"/><Cube currency="DKK" rate="7.4465"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8472"/><Cube
currency="HUF" rate="280.4"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.7035"/><Cube currency="PLN" rate="4.526"/><Cube
currency="RON" rate="4.22"/><Cube currency="SEK" rate="10.8345"/><Cube
currency="CHF" rate="1.511"/><Cube currency="NOK" rate="8.9055"/><Cube
currency="HRK" rate="7.235"/><Cube currency="RUB" rate="43.2745"/><Cube
currency="TRY" rate="2.1438"/><Cube currency="AUD" rate="1.7285"/><Cube
currency="BRL" rate="2.6851"/><Cube currency="CAD" rate="1.569"/><Cube
currency="CNY" rate="9.4684"/><Cube currency="HKD" rate="10.7344"/><Cube
currency="IDR" rate="14090.25"/><Cube currency="INR" rate="66.085"/><Cube
currency="KRW" rate="1742.1"/><Cube currency="MXN" rate="18.6982"/><Cube
currency="MYR" rate="4.8871"/><Cube currency="NZD" rate="2.1953"/><Cube
currency="PHP" rate="67.054"/><Cube currency="SGD" rate="2.019"/><Cube
currency="THB" rate="47.353"/><Cube currency="ZAR" rate="11.1603"/></Cube>
<Cube time="2009-06-12"><Cube currency="USD" rate="1.4004"/><Cube
currency="JPY" rate="137.55"/><Cube currency="BGN" rate="1.9558"/><Cube
currency="CZK" rate="26.655"/><Cube currency="DKK" rate="7.4457"/><Cube
currency="EEK" rate="15.6466"/><Cube currency="GBP" rate="0.8538"/><Cube
currency="HUF" rate="277.81"/><Cube currency="LTL" rate="3.4528"/><Cube
currency="LVL" rate="0.6966"/><Cube currency="PLN" rate="4.4791"/><Cube
currency="RON" rate="4.2001"/><Cube currency="SEK" rate="10.7555"/><Cube
currency="CHF" rate="1.5099"/><Cube currency="NOK" rate="8.8845"/><Cube
currency="HRK" rate="7.2582"/><Cube currency="RUB" rate="43.3717"/><Cube
currency="TRY" rate="2.1532"/><Cube currency="AUD" rate="1.7255"/><Cube
currency="BRL" rate="2.7099"/><Cube currency="CAD" rate="1.5708"/><Cube
currency="CNY" rate="9.5701"/><Cube currency="HKD" rate="10.8543"/><Cube
currency="IDR" rate="14138.5"/><Cube currency="INR" rate="66.664"/><Cube
currency="KRW" rate="1750.32"/><Cube currency="MXN" rate="18.7584"/><Cube
currency="MYR" rate="4.9091"/><Cube currency="NZD" rate="2.1893"/><Cube
currency="PHP" rate="66.418"/><Cube currency="SGD" rate="2.0338"/><Cube
currency="THB" rate="47.768"/><Cube currency="ZAR"
rate="11.2452"/></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 INTO @tmp
----OUTPUT inserted.*
--SELECT
-- N'EUR' as curCodeFrom
-- ,t.c.value('@currency', 'nvarchar(25)') as curCodeTo
-- ,t.c.value('../@time', 'date') as cerAsOfDate
-- ,t.c.value('@rate', 'decimal(19,6)') as cerExchangeRate
--FROM @x.nodes('gesmes:Envelope/Cube/Cube/Cube') as t(c);

;WITH XMLNAMESPACES
(
DEFAULT 'http://www.ecb.int/vocabulary/2002-08-01/eurofxref'
,'http://www.gesmes.org/xml/2002-08-01' as gesmes
)
--INSERT INTO @tmp
--OUTPUT inserted.*
SELECT
N'EUR' as curCodeFrom
,e.c.value('@currency', 'nvarchar(25)') as curCodeTo
,t.c.value('@time', 'date') as cerAsOfDate
,e.c.value('@rate', 'decimal(19,6)') as cerExchangeRate
FROM @x.nodes('gesmes:Envelope/Cube/Cube') as t(c)
CROSS APPLY t.c.nodes('Cube') e(c);

"Bob" <B...@discussions.microsoft.com> wrote in message
news:EB0D1501-775B-4503...@microsoft.com...

Bob

unread,

Sep 10, 2009, 10:09:01 AM9/10/09

Cool! That's good news.

WCM

unread,

Sep 13, 2009, 1:22:01 PM9/13/09

Hi again Bob,

Your response is useful to me in several ways:
1) When I ran your query for the first time I got an invalid xml error; this
was due to my not having installed Sql Server 2005 sp3 on my home, Developer
edition; once I installed sp3 your query ran 8X faster than my original;

2) One problem: your query returns 8,134 fewer rows than my query, and there
appear to be 5,163 rec values missing from your query (rec is an identity
column in the original table 'noder') - these rec values do appear in my
query results, and there are -0- rec values in the original 'noder' table
that do not appear in my query results;

3) It is not immediately apparent to me why your query would return
different results than mine; are you able to see anything??

Thanks for all your help - this investigation is really going to improve
performance on this end; just need to resolve this one issue.

WCM

unread,

Sep 13, 2009, 4:34:01 PM9/13/09

Hi Bob,

I believe that the discrepancy between your query return and mine is due to
the fact that for exactly 8,134 records [Reccipient] and [Recipient2] and
[Addr] columns are null. Doesn't this mean that those records will not be
returned by CROSS APPLY, even though there is a non-null value in
[NetAmount]?

So in your query, wouldn't you need to use OUTER APPLY instead of CROSS
APPLY so that null values are included in the return? When I replace CROSS
APPLY in your query with OUTER APPLY, your query and my query return
precisely the same results. Your query however, runs 8 times faster than
mine!

Thanks ...

Bill

Bob

unread,

Sep 14, 2009, 6:47:01 AM9/14/09

Yep OUTER APPLY is a bit like a LEFT JOIN.

HTH

WCM

unread,

Sep 14, 2009, 7:55:01 AM9/14/09

One final question: I need to know how sql server is interpreting this code.
It seems that it is "applying" the columns selected above to each row
returned by the nodes() method below. In other words, each row returned by
the nodes() method is like a derived table, so that "cross apply" or "outer
apply" is saying "inner join" or "left outer join" respectively to each row
returned by nodes() method.
That sound right?

Bob

unread,

Sep 14, 2009, 4:14:01 PM9/14/09

Have a look through the nodes section of this article which can explain it
better than me.

http://msdn.microsoft.com/en-us/library/ms190798(SQL.90).aspx

WCM

unread,

Sep 15, 2009, 1:02:01 PM9/15/09

I'm pretty clear on what the nodes() method will do. 'Grokking' how it
behaves with cross apply is where I'm a little fuzzy. Will read more stuff.
Thanks again for all your replies.

Bill

Bob

unread,

Sep 16, 2009, 5:48:01 AM9/16/09

From BOL:

"The APPLY operator allows you to invoke a table-valued function for each
row returned by an outer table expression of a query. The table-valued
function acts as the right input and the outer table expression acts as the
left input. The right input is evaluated for each row from the left input and
the rows produced are combined for the final output. The list of columns
produced by the APPLY operator is the set of columns in the left input
followed by the list of columns returned by the right input. "

So in your example, CROSS APPLY allows us to use the nodes method ( or
function ) of the xml data-type, pass parameters into is (via XPath) and
return the results. Repeated use to CROSS APPLY allows us to drill down into
XML.

HTH

0 new messages