title: How to insert rows to value
body: <p>Have table with values</p>
  <pre><code>CREATE TABLE #tbl 
      (
         id int  identity(1,1),
         object_type int ,
         object_id nvarchar(50),
         refl nvarchar(4000)
      )
  </code></pre>
  <p><strong>refl</strong> value have parametres like :</p>
  <pre><code>&lt;prov&gt;&lt;CProv&gt;&lt;object_type&gt;1&lt;/object_type&gt;&lt;object_id&gt;152&lt;/object_id&gt;&lt;/CProv&gt;&lt;/prov&gt;
  &lt;prov&gt;&lt;CProv&gt;&lt;object_type&gt;0&lt;/object_type&gt;&lt;object_id&gt;150&lt;/object_id&gt;&lt;/CProv&gt;&lt;/prov&gt;
  &lt;prov&gt;&lt;CProv&gt;&lt;object_type&gt;0&lt;/object_type&gt;&lt;object_id&gt;156&lt;/object_id&gt;&lt;/CProv&gt;&lt;/prov&gt;
  &lt;prov&gt;&lt;CProv&gt;&lt;object_type&gt;1&lt;/object_type&gt;&lt;object_id&gt;172&lt;/object_id&gt;&lt;/CProv&gt;&lt;/prov&gt;
  </code></pre>
  <p>I want to select all data which is in refl to another value <code>declare @val nvarchar(4000)</code> .
  Is it possible ? When I try <code>select @val = refl from #tbl</code> it select only last row, I want to select all rows. How do it? It must be like</p>
  <pre><code>@val = N'&lt;prov&gt;&lt;CProv&gt;&lt;object_type&gt;1&lt;/object_type&gt;&lt;object_id&gt;152&lt;/object_id&gt;&lt;/CProv&gt;&lt;/prov&gt;
      &lt;prov&gt;&lt;CProv&gt;&lt;object_type&gt;0&lt;/object_type&gt;&lt;object_id&gt;150&lt;/object_id&gt;&lt;/CProv&gt;&lt;/prov&gt;
      &lt;prov&gt;&lt;CProv&gt;&lt;object_type&gt;0&lt;/object_type&gt;&lt;object_id&gt;156&lt;/object_id&gt;&lt;/CProv&gt;&lt;/prov&gt;
      &lt;prov&gt;&lt;CProv&gt;&lt;object_type&gt;1&lt;/object_type&gt;&lt;object_id&gt;172&lt;/object_id&gt;&lt;/CProv&gt;&lt;/prov&gt;'
  </code></pre>