Results in specific format

• Maverick100877

  SSCertifiable

  Points: 5240

  More actions

  March 17, 2008 at 4:39 am

  #185285

  Hi,

  I have a table with one column. Now I want to display the results in a specific format.

  CREATE TABLE #TempTable

  (

  Question varchar(30)

  )

  GO

  INSERT INTO #TempTable(Question) VALUES ('First');

  GO

  INSERT INTO #TempTable(Question) VALUES ('Second');

  GO

  INSERT INTO #TempTable(Question) VALUES ('Third');

  GO

  INSERT INTO #TempTable(Question) VALUES ('Fourth');

  GO

  INSERT INTO #TempTable(Question) VALUES ('Fifth');

  GO

  INSERT INTO #TempTable(Question) VALUES ('Sixth');

  GO

  SELECT * FROM #TempTable

  --First,Second,Third,Fourth,Fifth,Sixth

  These results needs to be shown as columns.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  March 17, 2008 at 5:06 am

  #790266

  Presentation is usually a job for the application layer. However, if you want to do it with T-SQL, you can do something like this:

  DECLARE @List varchar(1000)

  SET @List = ''

  SELECT @List = @List + Question + ', '

  FROM #TempTable

  SET @List = LEFT(@List, LEN(@List) - 1) --chop off the last comma

  SELECT @List AS List

  Bear in mind, though, that the results could come out in any order, and not necessarily the order in which you inserted them into the table.

  John