<div>
What criteria are you using to consider a record as a duplicate? Just the FirstLastName column?
</div>


What criteria are you using to consider a record as a duplicate? Just the FirstLastName column?

<div>
<div class="content wysiwyg-content">
I have the following records in my temporary &nbsp;table which I have duplicates I am working: I would like the schoolID match. <br />
<br />
tempid &nbsp; &nbsp; &nbsp; &nbsp;fullname &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FirstLastName &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;schoolid &nbsp; &nbsp; &nbsp;birthdate &nbsp; &nbsp; &nbsp; &nbsp; ssn &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sourceid<br />
35 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;John H Smith &nbsp; &nbsp; John smith &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;77777 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/0179 &nbsp; &nbsp; &nbsp;999-99-9999 &nbsp; &nbsp;JXX5<br />
89 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John Smith &nbsp; &nbsp; &nbsp; John Smith &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;66666 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xxxxxx &nbsp; &nbsp; &nbsp; &nbsp;xxxxxx &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FFF7<br />
&nbsp;this is just an example but I have a 100 pairs in my &nbsp;temp table and I am looking for a solution to automate the update.<br />
My objective is to make the schoolid match. In here, I would like update tempID 89 to the same schoolid like tempid 35 -77777. &nbsp;I would prefer sourceid FFF7 follow and match all schoolIds of sourceid JXX5.<br />
<br />
thanks!<br />
<br />
<br />

</div>
</div>


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.

thanks!




Update records in same table

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.