SQL Server split string with delimiter
<p>I have an input string </p>

<pre><code>100|2|3,101|2|1,103|2|3.
</code></pre>

<p>I would like to parse and add this in table having 3 columns so it should go f.x</p>

<pre><code> col1 col2 col3 
 100   2     3
</code></pre>

<p>similar other data separated by comma as record and <code>|</code> as column.</p>

<p>Thanks</p>

<p>nik</p>