title: Converting comma delimited string to multiple columns in sql server
body: <p>I want to extract specific strings separated by a comma and parse across the specific columns in SQL server 2008. The table structure in SQL server is as follows:</p>
  
  <pre><code>CREATE TABLE SAMP(COMMASEPA VARCHAR(255),X VARCHAR(10),Y VARCHAR(10),Z VARCHAR(10),A VARCHAR(10),B VARCHAR(10),C VARCHAR(10),D VARCHAR(10))
  INSERT INTO SAMP VALUES('X=1,Y=2,Z=3',null,null,null,null,null,null,null),
  ('X=3,Y=4,Z=5,A=6',null,null,null,null,null,null,null),
  ('X=1,Y=2,Z=3,A=5,B=6,C=7,D=8',null,null,null,null,null,null,null)
  </code></pre>
  
  <p>I want the string to be separated based on comma and ONE of the strings in <code>[x/y/z/a/b/c/d]</code>. For example in the result table for first row X=1 should be in X col, Y=2 should be in Y col, Z=3 should be in Z col. Please input any ideas in doing this. Thank you…</p>