title: how can switch column data into row data using sql server
body: <p>i have a table like:</p>
  
  <pre><code>ID   value
  3      1
  3      2
  3      3
  3      4
  3      5
  3      6
  </code></pre>
  
  <p>Can anyone help me to convert this table into format:</p>
  
  <pre><code>ID  Value
  3   1,2,3,4,5,6
  </code></pre>