Combine rows and aggregate VARCHAR column using Comma

• Husain_Kachwala

  Ten Centuries

  Points: 1054

  More actions

  September 6, 2011 at 12:55 am

  #148709

  Hi all,

  I have the following scenario:

  Col1 Col2 Col3 Col4

  SD 23 UY 14

  SD 23 XV 14

  FD 26 UY 16

  I want the o/p to look something like:

  Col1 Col2 Col3 Col4

  SD 23 UY,XV 14

  FD 26 UY 16

  Could somebody help me with this????

  Thanks in anticipation!!!

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  September 6, 2011 at 12:58 am

  #1377187

  Hi ,

  try this article

  http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

  ---

  
  Clear Sky SQL
  My Blog[/url]