May 2, 2002 at 2:59 am
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
May 2, 2002 at 4:39 am
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)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy