Merging records with the same company name

[fcoomermd]

This is what I am having troubles with.
If I have a table like this:
Source -- CompanyName--Address---------City
Joe Ford 1185 Jones St Null
Bill Ford Null Arizona
Joe Samsung Null Chicago
Bill Samsung 185 Toledo StLouis

This what I need to do, merge the records where the company is the same, filling in all the null fields. And when both records have a value for a field, the record that has a Joe Source take priority...
So far, I have seperated these into two tables... One with the Source=Joe, and another with Source=Bill.

So, in the end... the output would be
Source -- CompanyName--Address---------City
Joe Ford 1185 Jones St Arizona
Joe Samsung 185 Toledo Chicago

Thanks alot
Fred

 

[Kurniadi]

Hi Fred..

I think you can do it with the processing of record one by one from two tables. You can use @@FETCH_STATUS.

Thank's
Kurniadi