Multpile rows in a single row

• tripri

  SSCommitted

  Points: 1584

  More actions

  August 23, 2010 at 4:31 pm

  #225174

  Hi i got a table which has data like

  Table

  Col1----col2----Col3

  X--------1-------a

  X--------1--------b

  X--------1--------c

  Y--------2-------e

  Y--------2--------f

  Z--------2-------g

  Z--------2-------h

  i should get an out put which looks like

  col1---col2---col3

  x------1------a,b,c

  y------2-------e,f

  z------2--------g,h

  Can any one help me out with this...

  Thank you

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  August 23, 2010 at 4:42 pm

  #1210731

  tripri (8/23/2010)

  ---

  Hi i got a table which has data like

  Table

  Col1----col2----Col3

  X--------1-------a

  X--------1--------b

  X--------1--------c

  Y--------2-------e

  Y--------2--------f

  Z--------2-------g

  Z--------2-------h

  i should get an out put which looks like

  col1---col2---col3

  x------1------a,b,c

  y------2-------e,f

  z------2--------g,h

  Can any one help me out with this...

  Thank you

  Is this homework? what do you got so far?

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

• Tarun Jaggi

  Hall of Fame

  Points: 3365

  More actions

  August 25, 2010 at 2:17 am

  #1211492

  Try this....

  SELECT DISTINCT c1.Col1, c1.Col2,

  STUFF((SELECT ',' + Col3 FROM Tablename c WHERE c.Col1 = c1.Col1 FOR XML PATH('')),1,1,'')

  FROM Tablename c1