How to Put Vertical Column Value into the same row

• Tapash Sengupta

  Grasshopper

  Points: 13

  More actions

  January 24, 2005 at 11:56 am

  #87797

  Hi,

  I have a table in the following format.

  Title                      Name

  Manager                John Doe

  Manager                 Mr. X

  Manager                 Ms. Y

   

  I'd like is to have the resultset in the following format for my Reporting.

  Title                       Name

  Manager                 John Doe;Mr. X; Ms. Y

   

  Any help would be really appreciated. Thanks a lot.

   

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 24, 2005 at 1:07 pm

  #538809

  See if this helps: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=156835

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  January 25, 2005 at 5:31 pm

  #539072

  Something like this:

   

  IF EXISTS( SELECT * FROM sysobjects WHERE name = 'T1' )

   DROP TABLE T1

  GO

  CREATE TABLE T1(  C1  NCHAR(1)  )

  SET NOCOUNT ON

  INSERT T1 VALUES( 'A' )

  INSERT T1 VALUES( 'B' )

  INSERT T1 VALUES( 'C' )

  DECLARE @str VARCHAR (50) -- attention with size, can trim results

   SET @str = ' '

   SELECT @str = @str + C1 + '; ' -- any separator here, like '|', ' ', ','

     FROM  T1

   SELECT  @str

  DROP TABLE T1