This really doesn't explain anything about selecting values from Elements in the Xml. You should have explained both scenarios: 1.) having values as Attributes (which you did) and 2.) having values at the Element level.

For example, I have the following Xml and want to retrieve it as a select statement. Everything is fine, except that all my columns are of DataType "XML"! How would I get these to be of a certain type (i.e. Int, VarChar, etc.)??

Declare @FeatureData Xml

Set @FeatureData = '

<DocumentElement>

<Features>

<TableID>-1</TableID>

<ID>-1</ID>

<Name>Bering Sea</Name>

<Prefix />

<Suffix />

<FeatureType />

<Version>06.10</Version>

<FileID>02013</FileID>

<LineID>1</LineID>

</Features>

</DocumentElement>'

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('Suffix/text()') As Suffix,

doc.rows.query('FeatureType/text()') As FeatureType,

doc.rows.query('Version/text()') As Version,

doc.rows.query('FileID/text()') As FileID,

doc.rows.query('LineID/text()') As LineID

FROM @FeatureData.nodes('//Features') As doc(rows)

Any ideas?