Remove Root XML nodes from default output of Sql Server statement
<p>I want @MyActualXMLOut to look like @MyDesiredXMLOut... How? Thanks in advance!</p>

<p>@MyDesiredXMLOut = </p>

<pre><code>&lt;MyRequiredRoot&gt;
  &lt;Property1&gt;Value1&lt;/Property1&gt;
  &lt;Property2&gt;Value2&lt;/Property2&gt;
&lt;/MyRequiredRoot&gt;
</code></pre>

<p>@MyActualXMLOut</p>

<pre><code>&lt;_x0040_MyTableVar&gt;
  &lt;MyXML&gt;
    &lt;MyRequiredRoot&gt;
      &lt;Property1&gt;Value1&lt;/Property1&gt;
      &lt;Property2&gt;Value2&lt;/Property2&gt;
    &lt;/MyRequiredRoot&gt;
  &lt;/MyXML&gt;
&lt;/_x0040_MyTableVar&gt;
</code></pre>

<p>The code below can be run as is...</p>

<pre><code>DECLARE @MyDesiredXMLOut XML;
DECLARE @MyActualXMLOut XML;

SELECT @MyDesiredXMLOut =
   CONVERT( XML, 
   '&lt;MyRequiredRoot&gt;&lt;Property1&gt;Value1&lt;/Property1&gt;
      &lt;Property2&gt;Value2&lt;/Property2&gt;
    &lt;/MyRequiredRoot&gt;' );

DECLARE @MyTableVar table( ID int NOT NULL, MyXML XML NOT NULL );

INSERT INTO @MyTableVar VALUES( 1, @MyDesiredXMLOut )

SELECT @MyActualXMLOut = 
    ( SELECT MyXML
      FROM   @MyTableVar
      WHERE  ID = 1
      FOR XML AUTO )

SELECT @MyDesiredXMLOut;

SELECT @MyActualXMLOut;
</code></pre>