title: T-SQL: How can I split comma seperated values from a column to rows?
body: <p>I have the following table (the number of the references is variable): </p>
  
  <pre><code>Id | FK_ID| Reference |
  -----------------------
  1    2100   GI2, GI32
  2    2344   GI56  
  </code></pre>
  
  <p>And I need the following result:</p>
  
  <pre><code>Id | FK_ID| Reference |
  -----------------------
  1    2100   GI2 
  2    2100   GI32
  3    2344   GI56  
  </code></pre>
  
  <p>Is there any short way to transform the data like this using MS SQL Server 2005?</p>
  
  <p>Thank you</p>
  
  <p>EDIT: Direct link to the solution: 
  <a href="http://www.sommarskog.se/arrays-in-sql-2005.html#iter-list-of-strings" rel="nofollow noreferrer" title="Direct link to the solution">http://www.sommarskog.se/arrays-in-sql-2005.html#iter-list-of-strings</a></p>