Update records in same table
Posted on 2007-07-25
I have the following records in my temporary table which I have duplicates I am working: I would like the schoolID match.
tempid fullname FirstLastName schoolid birthdate ssn sourceid
35 John H Smith John smith 77777 01/0179 999-99-9999 JXX5
89 John Smith John Smith 66666 xxxxxx xxxxxx FFF7
this is just an example but I have a 100 pairs in my temp table and I am looking for a solution to automate the update.
My objective is to make the schoolid match. In here, I would like update tempID 89 to the same schoolid like tempid 35 -77777. I would prefer sourceid FFF7 follow and match all schoolIds of sourceid JXX5.