You need to look at the nodes() syntax for parsing XML. Something like:

declare @x xml

set @x='<Data>

<Insurance>Yes</Insurance>

<_x0031_._x0020_ealth>Yes</_x0031_._x0020_ealth>

<Income_x0020_sources>Yes</Income_x0020_sources>

<Non_x0020_Cash_x0020_Benefits>Yes</Non_x0020_Cash_x0020_Benefits>

<Monthly_x0020_Income>

<Monthly_x0020_Income_x0020_ST>

<Source>Earned Income</Source>

</Monthly_x0020_Income_x0020_ST>

<Monthly_x0020_Income_x0020_ST>

<Source>Unemployment Insurance</Source>

</Monthly_x0020_Income_x0020_ST>

<Monthly_x0020_Income_x0020_ST>

<Source>Supplemental Security Income</Source>

</Monthly_x0020_Income_x0020_ST>

<Monthly_x0020_Income_x0020_ST>

<Source>Social Security Disability Income</Source>

</Monthly_x0020_Income_x0020_ST>

<Monthly_x0020_Income_x0020_ST>

<Source>VA Service-Connected DIsability Compensation</Source>

</Monthly_x0020_Income_x0020_ST>

<Monthly_x0020_Income_x0020_ST>

<Source>VA Non-Service Connected Disability...

drew.allen (12/12/2016)

---

SQLUSERMAN (12/10/2016)

---

Suppose I want to find customers in the customers table who are not in the US or the UK.

To me the query for the above requirements would be...

TomThomson (12/7/2016)

---

Matt Miller (#4) (12/6/2016)

---

I could see the value of an organization for monitoring work product and skills, but ethics aren't a skill. Ethics are a trait: you can't...

Jeff Moden (12/2/2016)

---

A lot...

Steve Jones - SSC Editor (11/30/2016)

---

roger.plowman (11/30/2016)

---

Don't do things that don't work. We've been down the certification road before, many times. It never works well. A guild/union wouldn't work any...

Eric M Russell (12/1/2016)

---

Other than something like pushing a deployment outside the formal change control process or granting someone elevated permissions, has anyone here ever been asked to compromise their...

TomThomson (7/15/2016)

---

liver.larson (7/8/2016)

---

I think this a pretty fantastic vision, really. It's easy to get caught up in the practical challenges of what it would take to even take a meaningful...

David.Poole (11/8/2016)

---

Rod at work (11/8/2016)

---

This is a bit of a tangent, but I had to respond to the mention of Gartner. Before I came to my current job all I...

Gary Varga (2/22/2013)

---

marcia.j.wilson (2/21/2013)

---

Keith Langmead (2/21/2013)

---

...The only issue I have with this idea is that it assumes you're capable of providing a solution, and it's quite possible that won't be...

Rod at work (11/2/2016)

---

David.Poole (11/2/2016)

---

Terry Pratchett described how the city of Ankh Morpork dealt with a plague of rats by paying a bounty on dead rats delivered. Despite this...

Clearly not if I've had...

It might help if you shared the actual query and perhaps what you're using to view the query output. Scientific notation seems to imply that some part of this...

Gary Varga (10/27/2016)

---

Matt Miller (#4) (10/27/2016)

---

Not sure on that one.

I for...

Not sure on that one.

I for one was trying to get...

Still ultimately the same idea, except that you'd cross join your product table with the Tally table (which fills in each product by month in the same way as I...