SQL Server import row string to table columns
<p>I have a table containing the following text per row</p>

<pre><code>"[0,0,0,1,2,4,1,0,0,2,0,0,0,0,847,18207,0,0,0,0,0,0,0,0,0,0,0,0]"
</code></pre>

<p>Now i want to insert these 28 values in a table containing 28 <strong>columns</strong>. I tried a few split functions but these would return only rows.</p>

<p>Any ideas?</p>