changing the output format in select statement

• ssurekha2000

  SSCommitted

  Points: 1860

  More actions

  August 26, 2013 at 12:24 am

  #281570

  i get values in a coulmn NAME (- column name) as rows

  i need to get the output in a single line

  Example

  select Name from customers where id in(@id1,@id3)

  i get the output as

  Name - column name

  John

  Smith

  I need the output as

  Name - column name

  John And Smith

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  August 26, 2013 at 1:24 am

  #1644802

  Take a look at this excellent article on how to concatenate row values:

  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