Extract information from not structured XML-string
I’m trying to extract information with SQL from a XML column which looks like this:
How to query XML in SQL to find an element by partial text() match
Given the following XML in a table column:
How to query XML in SQL to find an element by partial name match
Given the following XML in a table column:
How to get XML block number with SQL Server?
I have document:
How to query XML in SQL and return a list of all nodes
I’ve got an SQL table with one XML column, and I want to query the XML and get the id/@extension and also a list all observation/code. However it always returns empty results. I’ve isolated an example table with representative test data, see below