Comma separated column output.

• vignesh.ms

  Hall of Fame

  Points: 3456

  More actions

  November 19, 2013 at 11:37 pm

  #300673

  Hi There,

  I need a query which results the output as comma separated

  for example ,

  select name from tablename;

  say for example this produces the following,

  Name

  Jack

  John

  Smith

  I need the follwoing,

  Jack,John,Smith

  -------------------

  Thanks Many

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  November 19, 2013 at 11:54 pm

  #1667677

  Concatenating Row Values in Transact-SQL[/url]

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• vignesh.ms

  Hall of Fame

  Points: 3456

  More actions

  November 20, 2013 at 1:15 am

  #1667695

  Koen Verbeeck (11/19/2013)

  ---

  Concatenating Row Values in Transact-SQL[/url]

  Thanks. good one teaches me a lot.