title: SQL Server 2000 XML PATH('') error
body: <pre><code>SELECT
  **FIELDS**
  AS [text()] --Stops the XMLPATH line rendering output as XML
  FROM #temp
  WHERE  **CONDITIONS**
  FOR XML PATH('') 
  </code></pre>
  
  <p>This doesn't work in SQL server 2000 (unsupported).
  I have tried using <code>FOR XML RAW</code> but it returns loads of useless information. i.e:</p>
  
  <pre><code> &lt;row text x0028 x0029="blah, blah"&gt; &lt;row text x0028 x0029="blah"&gt; 
  </code></pre>
  
  <p>The above code currently returns a concatenated string(made up of multiple columns of varying types) from every single row in the table.</p>
  
  <p>How can I achieve this in SQL Server 2000?</p>