XML parsing error: why is semicolon expected?
<p>I'm a newbie struggling with trying to import XML from an external third-party into SQL Server. I tried this SQL with the XML below and it pukes with "XML parsing: line 10, character 81, semicolon expected" in the middle of the Name tag - WHY?? Why would it expect a semicolon in the middle of a value? Any suggestions?? Thanks in advance!</p>

<pre><code>CREATE TABLE XMLD (Id INT IDENTITY PRIMARY KEY, XMLData XML)

INSERT INTO XMLD(XMLData) SELECT CONVERT(XML, BulkColumn) AS BulkColumn FROM OPENROWSET(BULK 'D:\Details-WaUSA-1027.xml', SINGLE_BLOB) AS x;
</code></pre>

<blockquote>
  <p>ERROR: XML parsing: line 10, character 81, semicolon expected</p>
</blockquote>

<pre><code>&lt;OnlineReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Version="1.0" From="10/27/2016" To="10/27/2016" xsi:noNamespaceSchemaLocation="Responses.xsd"&gt; &lt;Site ID="130421" Name="Prod-B2B-PC-Server"&gt; &lt;Responses/&gt; &lt;/Site&gt; &lt;Site ID="130739" Name="Prod-B2B-PC-Item"&gt; &lt;Responses&gt; &lt;Response&gt; &lt;ID&gt;86947636057&lt;/ID&gt; &lt;Name&gt; https://store.shop4e.com/node/Shop4e/index.php?route=product/product&amp;product_id=18922&amp;userId=150802 &lt;/Name&gt; &lt;URL/&gt; &lt;Monitoring-Date-Time&gt;10/27/2016 12:45:39 PM&lt;/Monitoring-Date-Time&gt; &lt;ResponseStartTime&gt;2016-10-27 12:45:39.170&lt;/ResponseStartTime&gt; &lt;Duration&gt;7954&lt;/Duration&gt; &lt;Status&gt;S&lt;/Status&gt; &lt;Monitoring-Location&gt;WA, USA&lt;/Monitoring-Location&gt; &lt;/Site&gt; &lt;/OnlineReport&gt;
</code></pre>