Need to write a query to get following output

• vikas_yadav24

  SSC Eights!

  Points: 851

  More actions

  August 3, 2009 at 5:12 am

  #212776

  Table Data

  A 1

  A 2

  A 3

  B 4

  B 5

  Output :

  A 1,2,3

  B 4,5

  What should be the query to get this output?

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  August 3, 2009 at 5:50 am

  #1033595

  Have a look at this link http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

  Particularly "The blackbox XML methods"

• vikas_yadav24

  SSC Eights!

  Points: 851

  More actions

  August 3, 2009 at 9:58 am

  #1033746

  thanks a lot. It was very helpful.