Aggregate Function for Varchar Column

• tamtaly

  SSC Veteran

  Points: 207

  More actions

  March 28, 2007 at 12:39 am

  #116270

  Hi all,

  I want to Get the Varchar Column in the Group by.

  Example:

  Employees Table:

  EmpType  EmpName

  1             Ram

  2             Raja

  1             John

  2             Tom

  1             Adam

  I need a output in group by EmpType like this:

  EmpType        EmpName

  1                   Ram, John, Adam

  2                   Raja , Tom

   

  Thanks & Regards,

  Tamil

• upalsen

  Old Hand

  Points: 381

  More actions

  March 28, 2007 at 2:10 am

  #697330

  this needs a trick to be applied... check the link below...

  http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/rowset-string-concatenation-which-method-is-best.aspx