xml nodes()

DECLARE @T varchar(max) 
SET @T = 
'<root>
    <Field FieldRowId="1000">
        <Items>
                <Item Name="CODE"/>
                <Item Name="DATE"/>
        </Items>
    </Field>
    <Field FieldRowId="2000">
        <Items>
                <Item Name="CODE"/>
                <Item Name="DATE"/>
        </Items>
    </Field>
</root>'
DECLARE @X xml
SET @X = CAST(@T as xml)
SELECT Y.col.value('../../@FieldRowId', 'int') as FieldID, 
       Y.col.value('@Name', 'varchar(max)') as "Name"
FROM @X.nodes('/root/Field/Items/Item') as Y(col)