How to Transpose

• Stephen Bowley

  Valued Member

  Points: 50

  More actions

  November 8, 2005 at 10:56 am

  #169473

  and one know how to transpose is SQL easily?

  table looks like this

  {Name}

  john

  joe

  fred

  william

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

  need result set to look like this...

  john,joe,fred,william

   

   

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  November 8, 2005 at 11:21 am

  #602856

  SQL 2005 has PIVOT and UNPIVOT statements

  In SQL 2000 use Case or IF

  Regards,Yelena Varsha

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  November 8, 2005 at 11:21 am

  #602855

  DECLARE @NameList VARCHAR(255)
  SELECT @NameList = COALESCE(@NameList + ',', '') + Name
  FROM tblName
  PRINT @NameList
  

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**