title: SQL Server Stored Procedure XML can't get node right
body: <p>I have this query here:</p>
  
  <pre><code>SELECT [Job_No] as '@Key',
  (
  )
  FOR XML PATH('Job_No'), ROOT('Root')
  </code></pre>
  
  <p>and it returns like so:</p>
  
  <pre><code>&lt;Root&gt;
    &lt;Job_No Key="ORC0023"&gt;
    &lt;/Job_No&gt;
  &lt;/Root&gt;
  </code></pre>
  
  <p>How do I get it like so:</p>
  
  <pre><code>&lt;Root&gt;
        &lt;Key&gt;ORC0023&lt;/Key&gt;
      &lt;/Root&gt;
  </code></pre>