title: For XML returning All column names as same element
body: <p>I have a requirement to return xml as follow</p>
  
  <pre><code>&lt;row id="1"&gt;
  &lt;cell&gt;1&lt;/cell&gt;
  &lt;cell&gt;setup/pagemst&lt;/cell&gt;
  &lt;cell&gt;Page Master&lt;/cell&gt;
  &lt;/row&gt;
  &lt;row id="2"&gt;
  &lt;cell&gt;2&lt;/cell&gt;
  &lt;cell&gt;setup/modules&lt;/cell&gt;
  &lt;cell&gt;Module Master&lt;/cell&gt;
  &lt;/row&gt;
  </code></pre>
  
  <p>I used the following Query but it does not work</p>
  
  <pre><code>select 
  pageid id,pgurl cell,pgname cell
  from m_pages
  for xml raw
  </code></pre>
  
  <p>The same column names for all columns works fine in oracle but not in SQL Server 2005. Any Ideas ?</p>
  
  <p>Thanks in advance
  deb</p>