The problem
Stored in a varchar column, payload_xml, we have xml that looks something like this:
<?xml version="1.0" encoding="utf-16"?>
<ReceiveMoneyParameters
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
...
<PaymentArrangementExternalReference>
JT00009084
</PaymentArrangementExternalReference>
...
</ReceiveMoneyParameters>
I need to return the underlined section as a varchar.
The solution
With the help of Tim Chapman's article...
Popular Posts
-
In Boris Gloger 's "Estimation in Depth" deep dive at the South African Scrum Gathering he introduced us to Magic estimation.... -
The problem Stored in a varchar column, payload_xml , we have xml that looks something like this: <?xml version="1.0" encod...
-
A few years back I met a young soul exploring software development. He had programmed some robots, learnt some python and gotten himself to ... -
On day 2 of the Cape Town Scrum Gathering (a.k.a. Scrum Safari) there were a few lightning talks in the afternoon. I was lucky enough to na...
-
Mohamed Bray Sugsa August 2010 This month's sugsa was a cross-talk from the Business Analysis community. The Talk Mohamed describ...
-
Or, how I learned to read the assembly name In which I include dll's I was trying out this tutorial on Geekpedia and the references w... -
All of us at Information Logistics took the break from routine to take part in the Scrum Safari . My mind's still processing the influx... -
Today I hosted the third code retreat at Information Logistics . Today was a great success with six awesome developers from around Cape T... -
Breaking it down: scrum i kanban agilistic xp lean i do cious Scrumikanbanagilisticxpleanidocious is a word I dreamed ...
-
This is the third in my Agile Contracting series . As with the previous post, this is a verbatim copy of my speech notes, with some mark-up...
