How to horizontally show columns record with group by (Challengin SQL Query To Write,At Least For Me))?

• howyue

  SSC-Addicted

  Points: 439

  More actions

  July 30, 2007 at 3:14 am

  #177748

  Table A:

  ColA	ColB
  A	John
  A	Bill
  B	Henry
  C	Keith
  C	Luke
  C	Peter

  Table B:

  ColA	ColB
  A	John, Bill
  B	Henry
  C	Keith, Luke, Peter

  I wan to write a query (without looping/cursor if possible) that can extract data from Table A and return resultset as Table B. Anyone who has done something similar before? i wanted to use COALESCE syntax, but no idea how to do it in this situation... Any suggestion will be much appreciated. Thankq.

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  July 30, 2007 at 3:50 am

  #723240

  See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

   

  ---

  N 56°04'39.16"
  E 12°55'05.25"