Epic XML SQL Query

epic.sql

DECLARE @MyXml XML

SET @MyXml = CAST('
<content>
    <item>
        <id>1</id>
        <path>foo</path>
    </item>
    <item>
        <id>2</id>
        <path>bar</path>
    </item>
    <item>
        <id>3</id>
        <path>foobar</path>
    </item>
</content>
' AS XML)

SELECT 
      field.value('(id)[1]','int') as FieldID,
      field.value('(path)[1]','varchar(500)') as FieldName
FROM 
      @MyXml.nodes('//item') as Fields(field)