title: SQL Server 2014 Replace Distinct? DeIdentify Data
body: <p>I am going to explain again what I am trying to do in hopes that you can help. </p>
  
  <p>Table 1 has 4061 rows with columns that include 
  [Name],[Address1],[Address2],[Address3],[City],[State],[Zip],[Country],[Phone]
   and 20 other columns. Table 1 is data that needs to be deidentified. Table 1 has 1534 distinct [Name] rows out of 4061 rows total. </p>
  
  <p>Table 2 has auto generated data which includes the same columns. I would like to replace the above mentioned columns in table 1 with data from table 2. I want to select distinct based on [Name] from table one and then [Name],[Address1],[Address2],[Address3],[City],[State],[Zip],[Country],[Phone] with a new set of distinct data from table 2. </p>
  
  <p>I do not want to just update each row with a new address as that will screw up the data consistency. By replacing only distinct this will allow me to preserve the data consistency while changing the row data in table 1. When I am done I would like to have 1534 distinct new de-identified [Name] [Address1],[Address2],[Address3],[City],[State],[Zip],[Country],[Phone] in table 1 from table 2.</p>