title: Split column values in a table separated with special character
body: <p>I have a table that looks like this:</p>
  <pre><code>Table 1
  
  +----+--------+----------+
  | ID | Name   |   SIZE   |      
  +----+--------+----------+
  | 1  | Style1 | S,M,L,XL |  
  +----+--------+----------+
  </code></pre>
  <p>I need to iterate through the whole table and load it into another table that looks like the following without using <code>SPLIT_STRING</code>, we are using  SQL Server 2012 without that capability.</p>
  <p>I also know that the max values that would be inserted into the new table would be 100 columns wide. I'm still new to SQL and not very comfortable with functions and how to utilize them.</p>
  <pre><code>Table 2
  
  +----+--------+-------+-------+-------+-------+-----+-------+
  | ID |  NAME  | SIZE1 | SIZE2 | SIZE3 | SIZE4 | ... | SIZEN |
  +----+--------+-------+-------+-------+-------+-----+-------+
  |  1 | Style1 | S     | M     | L     | XL    |     |       |
  +----+--------+-------+-------+-------+-------+-----+-------+
  </code></pre>
  <p>Thank you</p>