title: How to split the column and row values
body: <p>Using sql Server 2005</p>
  
  <pre><code>id value1 value2
  
  001 200 300
  002 200x300 400x200
  003 300x200 500x600
  004 100 200
  .....
  </code></pre>
  
  <p>i want to split the value column into 2 column</p>
  
  <pre><code>If value1 row 200x300 then it should display value1 - 200 and value2 - 300
  if value2 row 400x200 then it should display value1 - 400 and value2 - 200
  </code></pre>
  
  <p>Expected output</p>
  
  <pre><code>id value1 value2
  
  001 200 300
  002 200 300
  002 400 200
  003 300 200
  003 500 600
  004 100 200
  ....
  </code></pre>
  
  <p>How to do this.</p>
  
  <p>Need SQL Query Help</p>