Where is 'orderHeader' and 'x' set? 

Enjoyed the series. Found I had to make this change in the header insert.  Otherwise I get a datetime conversion error. 

 51         INSERT INTO OrderHeader (OrderNumber, OrderDate, CustomerNumber, OrderDate)   

   52         SELECT

   53             x.header.value('@orderNumber[1]', 'varchar(20)') as OrderNumber,

   54             x.header.value('@customerNumber[1]', 'varchar(20)') as customerNumber,

   55             x.header.value('@orderDate[1]', 'datetime') as OrderDate

   56             FROM @OrderInfo.nodes('//salesOrder') as x(header)

Not sure WHY this works, but it works.  I changed the Path in the FROM clause to include the /ID node, and then use .value method to get the value -1 as an int.  Note the pathing in the other .query method has to change.  Not sure how to apply .value to those the get the values out.  Surely, this is not that complicated.

Select
doc.rows.query('../ID/text()') As ID,
doc.rows.query('../Name/text()') As Name,
doc.rows.query('../Prefix/text()') As Prefix,
doc.rows.query('../FileID/text()') As FileID,
doc.rows.query('../LineID/text()') As LineID,
doc.rows.value('.','int')
FROM @FeatureData.nodes('//Features/ID') As doc(rows)

It is set from the "FROM" clause. Look at the following:

........FROM @x.nodes('//salesOrder') AS x(header)

Does this answer your question? It is a type of alias that we assign to the resultset.

hi ryan,

Let me present a quick example:

The following example extracts the attribute values:

SELECT

x.item.value('@code[1]', 'VARCHAR(20)') AS ItemCode,

x.item.value('@category[1]', 'VARCHAR(20)') AS category,

x.item.value('@subcategory[1]', 'VARCHAR(20)') AS subcategory

FROM @x.nodes('//orderInfo/item') AS x(item)

The following example extracts the values from xml nodes.

SELECT

x.item.value('description[1]', 'VARCHAR(20)') AS description,

x.item.value('qty[1]', 'INT') AS qty,

x.item.value('rate[1]', 'FLOAT') AS rate

FROM @x.nodes('//orderInfo/item') as x(item)

I am coming up with a new article which shows some advanced XML processing. I will present a few more practical examples in it. It will be on in the next few weeks.