SELECT * FROM XMLParser (
ON xml_input1
Text_Column ('xmldocument')
Nodes ('temperature/read:type', 'storage/{used, total}')
Sibling ('settopid:{type, length}', 'accountid')
Ancestor ('setTopRpt')
OutputColumn_NodeID ('nid')
MaxItemNum (1)
Accumulate ('xid')
) ORDER BY 1,2;