title: How to read XML file in stored procedure
body: <p>I read many titles on reading an XML in a stored procedure but still can't find the answer I am looking for. (this is my first post in stackoverflow so I am sorry if I don't format it correctly)</p>
  
  <p>Here is the sample XML file I need to read/parse in a stored procedure:</p>
  
  <pre><code>&lt;TABLENAME&gt;
     &lt;Fld Name="Field1"&gt;ValueInField1&lt;/Fld&gt;
     &lt;Fld Name="Field2"&gt;ValueInField2&lt;/Fld&gt;
     &lt;Fld Name="Field3"&gt;ValueInField3&lt;/Fld&gt;
  &lt;/TABLENAME&gt;
  </code></pre>
  
  <p>What I need (ideally) is to get one-row table where the column names would be Field1, Field2, Field3, and the values in these columns would be ValueInField1, ValueInField2, ValueInField3.</p>
  
  <p>Is this possible? If yes, how. Thank you in advance for any suggestions.</p>