title: SQL Cross Tab Function
body: <p>Hi Dear All My friends,</p>
  
  <p>I want to ask one thing about sql cross tab function.Currently, I am using sql 2008 express version and my table structure is like below.</p>
  
  <pre><code>UserID     Str_Value
  1             A
  1             B
  1             C
  2             A
  2             B
  3             D
  3             E
  </code></pre>
  
  <p>I want to get like this .</p>
  
  <pre><code>UserID     Str_Value
  1             A,B,C
  2             A,B
  3             D,E
  </code></pre>
  
  <p>I don't want to use cursor.Is there any function for that one?<br/>
  Please give me the right way.I really appreciate it.</p>
  
  <p>Thanks.</p>
  
  <p>Best Regards,</p>
  
  <p>Chong</p>