I have a database table which stores routing information but there are records which I would like to merge.
The schema is as follows
F1 - VARCHAR(30)
F2 - VARCHAR(40)
F3 - VARCHAR(6)
F4 - DATETIME
F5 - VARCHAR(40)
An example of a record is as follows:-
The issue is that there may be another record as follows:-
What we would like to do is somehow merge records, so that for the example above, we would have:-
I know that F4 is different but this doesn't matter so much - the main goal is to have records with the same F1 consoldated into 1 record with the F2 and F5 fields merged. In the database table that we've inherited, there is no more than 2 records with the same F1.
We were considering using a SQL command but unsure as to the command to use - any help on this would be greatly appreciated.