Posted by SQL on 09/26/05 22:35

Something like this (untested)

select o1.OldID,o1.OldNote + char(13) + coalesce(o2.OldNote) as
ComboNote from OldTable o1
left join OldTable o2 on o1.OldID =o2.OldID
and o1.OldNote <> o2.OldNote

http://sqlservercode.blogspot.com/

• Next in forum: Re: Consolidating Records
• Prev in forum: Consolidating Records
• Thread view: Re: Consolidating Records

[Reply to this message]