Merging many rows into one.

• russcooper

  SSC Enthusiast

  Points: 111

  More actions

  May 2, 2002 at 2:59 am

  #78800

  I need to "append" data in my rows together - clearer by example

  I have data, obtained by joining 2 tables :

  Name | LocationID | Location

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

  Russ | 1 | New York

  Russ | 2 | London

  I want to change the form to

  Name | Location1 | Location

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

  Russ | New York | London

  (I know there will be only be a max of 2 mappings )

  can anyone help ?

  Thanks

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 2, 2002 at 4:39 am

  #428275

  Duplicate post, see http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3959&FORUM_ID=8&CAT_ID=1&Topic_Title=Merging+many+rows+into+one%2E&Forum_Title=T%2DSQL for responses.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)