title: Empty table using XML PATH
body: <p>At this time I have a new table that is empty and I would like to use FOR XML PATH to build an xml return. In my c# code I have error related to missing root element.</p>
  
  <blockquote>
    <p>How would I return XML even if there is no content from the select?</p>
  </blockquote>
  
  <pre><code>SELECT 
  [CommitteeSurveryid]
  ,[GroupId]
  ,[SurveryTitle]
  ,[SurveryDate]
  ,[FileManagerid]
  FROM [CommitteSurvery] as cs
  WHERE (cs.GroupId = 620)
  FOR XML PATH('Items'), ROOT('CommitteeSurveryItem');
  </code></pre>
  
  <p>[<img src="https://i.stack.imgur.com/jlBzb.png" alt="SQL[1]"></p>