title: How can I to read a XML from a URL using T-SQL?
body: <p>Have xml file in url :</p>
  
  <pre><code>&lt;response&gt;
  &lt;sum&gt;0&lt;/sum&gt;
  &lt;result&gt;0&lt;/result&gt;
  &lt;comment&gt;sel*1.9488|buy*1.9453&lt;/comment&gt;
  &lt;/response&gt;
  </code></pre>
  
  <p>Now want stored procedure where i can parse this xml file from url and update into columns values which is in <code>&lt;comment&gt;sel*1.9488|buy*1.9453&lt;/comment&gt;</code> want add <strong>buy*1.9453</strong> to my table. How do it ?</p>