read XML in SQL, no data being pulled <p>I am trying to retrieve data from an XML file. Below is how the XML doc looks and below that is my SQL code. It will run the code and show column headers - but will not populate with any data. What am I missing?</p> <pre><code>&lt;profile xmlns="http://feed.elasticstats.com/schema/mma/v1/participants-profile.xsd" generated="2015-12-10T17:34:54Z"&gt; &lt;fighters&gt; &lt;fighter id="01585452-852a-4b40-a6dc-fdd04279f02c" height="72" weight="170" reach="" stance="" first_name="Sai" nick_name="The Boss" last_name="Wang"&gt; &lt;record wins="6" losses="4" draws="1" no_contests="0" /&gt; &lt;born date="1988-01-16" country_code="UNK" country="Unknown" state="" city="" /&gt; &lt;out_of country_code="UNK" country="Unknown" state="" city="" /&gt; &lt;/fighter&gt; &lt;fighter id="0168dd6b-b3e1-4954-8b71-877a63772dec" height="" weight="0" reach="" stance="" first_name="Enrique" nick_name="Wasabi" last_name="Marin"&gt; &lt;record wins="8" losses="2" draws="0" no_contests="0" /&gt; &lt;born date="" country_code="UNK" country="Unknown" state="" city="" /&gt; &lt;out_of country_code="UNK" country="Unknown" state="" city="" /&gt; &lt;/fighter&gt; </code></pre> <hr> <pre><code>DECLARE @x xml SELECT @x = P FROM OPENROWSET (BULK 'C:\Python27\outputMMA.xml', SINGLE_BLOB) AS FIGHTERS(P) DECLARE @hdoc int EXEC sp_xml_preparedocument @hdoc OUTPUT, @x SELECT * FROM OPENXML (@hdoc, '/fighters/fighter', 1) --1\ IS ATTRIBUTES AND 2 IS ELEMENTS WITH ( id varchar(100), height varchar(10), last_name varchar(100) ) --THIS IS WHERE YOU SELECT FIELDS you want returned EXEC sp_xml_removedocument @hdoc </code></pre>