question

When querying XML data, the most important part is to figure out which node to pick to represent the row of data. In this case, the XML is very simple, and the node representing a row is the node named Dig. From this node, what needs to be selected for each row is the following: 1. The value of the attribute named IsPrim 2. The inner text of the child node named Code 3. The inner text of the child node named Name The select statement (which includes the declaration/setting of the sample data) may look like this: -- sample xml data declare @x xml = ' 3342 abc 5342 xyz '; select x.value('@IsPrim[1]', 'varchar(5)') Dig_IsPrim, x.value('Code[1]', 'int') Code, x.value('Name[1]', 'varchar(10)') [Name] from @x.nodes('Dig') r(x); Based on the XML in question, this query produces the following result: Dig_IsPrim Code Name ---------- ----------- ---------- True 3342 abc False 5342 xyz Hope this helps. Oleg