Combine similar records ??? - SQL Server Forums

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 2008 Forums

Transact-SQL (2008)

Combine similar records ???

Author

Topic

darms21
Yak Posting Veteran

54 Posts

Posted - 2012-04-19 : 17:07:09

I have a table:

Serial | Note | NoteType
1 | 123 | A
1 | 456 | A
1 | Old | B
1 | Blah | B

I want to get the output:
Serial |A Note | B Note
1 |123, 456| Old, Blah

darms21
Yak Posting Veteran

54 Posts

Posted - 2012-04-20 : 09:27:45

Any ideas anyone?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-04-20 : 10:01:01

quote:
Originally posted by darms21

Any ideas anyone?

Yes, stop cross posting the same question in multiple forums:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=173794 -- original
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=173825

I'm locking this and the last topic. Please stay with the original thread, it only confuses people when you post the same question multiple times.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources