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 2005 Forums
 Transact-SQL (2005)
 Record consolidation

Author  Topic 

darms21
Yak Posting Veteran

54 Posts

Posted - 2012-04-20 : 09:28:33
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

ANy ideas?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-04-20 : 10:01:17
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=173794
Go to Top of Page
   

- Advertisement -