Posting Yak Master
Posted - 11/26/2012 : 17:34:09
| Hi there,
On Nov. 20 I submitted a question, see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=180820 and sodeep gives perfect anwer. But now the situation is little bit different:
when the same combinationed recored found, here is the first part of the codes:
Select CodeId,TypeId,ModelId,Count(*),Col1, Col2, ........
Group by CodeId,TypeId,ModelId
Having Count(*) > 1
Now I need merge col1 from duplicated records together. For example,
Id | Col1 | Col2 ...
11 | ABC | ...
13 | CBX | ...
after the merge, the save back record for Col1 should look like ABC,CBX and Col2 and the rest columns should remain intact.
How can I do this? Thanks in advance.