I would need to extract elements from this XML into a tabular form, but I can’t seem to get my head around how this would work on SQL Server via something like XQuery. I have all the data in a temporary table called “#1” and the XML itself lies in a field called “Message” in that temporary table. How can
Tag: xquery
XQUERY -SQL Retrieve list of child and parent ID
How I can query the xml in order to obtain the following result? I am completely new on using XQuery. XML sample: And the result: idAsig B1_1 B1_2 B1_3 B1_4 B1_5 1 NULL NULL NULL NULL NULL 2 1 0 N 8 4848 2 52 0 N 8 625 3 1 0 N 8 589 3 39 0 N 8
Numbering sequences from xml according element’s values
The PointNum attribute means the number of coordinates in the chain. The coordinate chain starts at 1 and ends at 1 as well (inside each Parcel element). However, within the sequences of these points, …
SQL – Blank default namespaces
I have a relation which has an XML column storing data in the following structure