join 2 rows to a column

• scottichrosaviakosmos

  SSCommitted

  Points: 1889

  More actions

  May 23, 2013 at 2:52 am

  #294323

  create table dbo.#abc([name] varchar(100),id int)

  insert into dbo.#abc([name],id)

  select 'Animal',100

  union

  select 'beer',100

  union

  select 'Tree',200

  union

  select 'Olive',200

  I want to have resultset as

  animal.beer

  tree.Olive.

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  May 23, 2013 at 2:55 am

  #1617755

  The below link will be useful to you

  http://www.sqlservercentral.com/articles/comma+separated+list/71700/

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/