Group by and comma seperated result

• Mak Mohan

  SSC Eights!

  Points: 994

  More actions

  October 3, 2008 at 12:06 am

  #198813

  Hi

  I am having following table:

  ProductId Category

  1 Sports

  1 Entertainment

  1 Science

  2 Culture

  2 Politics

  I want show following result:

  ProductId Categories

  1 Sports,Entertainment,Science

  2 Culture,Politics

• jacob sebastian

  SSChampion

  Points: 11822

  More actions

  October 3, 2008 at 1:33 am

  #880323

  Abhijeet,

  I have presented the sample code for achieving this in the following post: http://www.sqlserverandxml.com/2008/08/how-to-generate-delimited-string-using.html

  .

• Karthigai Rajan

  Mr or Mrs. 500

  Points: 500

  More actions

  October 3, 2008 at 7:24 am

  #880449

  Hi,

  The following is really a very good solution for your requirment.

  http://www.4guysfromrolla.com/webtech/092105-1.shtml

  Thanks.