title: Get the position of xml element in SQL Server 2012
body: <p>How to get the row number for the rows using SQL Server 2012?</p>
  
  <p>Here is the xml</p>
  
  <pre><code>&lt;Rows&gt;
     &lt;Row&gt;Coating&lt;/Row&gt;
     &lt;Row&gt;Drying&lt;/Row&gt;
     &lt;Row&gt;Waxing&lt;/Row&gt;
  &lt;/Rows&gt;
  </code></pre>
  
  <p>I need data returned like this</p>
  
  <pre><code>RowLabel  RowNumber
  -------------------
  Coating    1
  Drying     2
  Waxing     3
  </code></pre>