data from one column with multiple rows on one row

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

data from one column with multiple rows on one row

Author

Topic

Thanos
Starting Member

1 Post

Posted - 2005-08-22 : 17:29:23

I need to display the data from one column with multiple rows on one row.

Example

Name Pet
David Dog
Dawn Cat
Dawn Dog
Pete Cat
Pete Mouse
Pete Dog

I would like the result to be:

David Dog
Dawn Dog Cat
Pete Dog Cat Mouse

I will not know the row values ahead of time.

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-08-22 : 18:26:30

This is the third time that essentially the same question has come up in the last few weeks. Are y'all doing the same homework problem or something?

Here's a link to some previous answers: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53885

---------------------------
EmeraldCityDomains.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources