Find matching records based on dynamic columns

  
PetID
Address
Zip
Country
Document
OwnerName
OwnerID
Field1
Field2

1
1
123 5th st
12345
US
test.csv
John
5
NULL
NULL

2
2
234 6th st
23456
US
a.csv
Alex
6
NULL
NULL

3
3
345 7th st
34567
US
b.csv
Mike
1
NULL
NULL


  
(No column name)

1
UPDATE p 
                SET OwnerID = o.OwnerID 
                FROM temp_pets p 
                INNER JOIN temp_owners o ON p.Address = o.Addr AND p.Zip = o.Zip AND p.Country = o.Country AND p.OwnerName = o.Name 
                WHERE p.PetId = 1
                AND p.OwnerID IS NULL;
                UPDATE p 
                SET OwnerID = o.OwnerID 
                FROM temp_pets p 
                INNER JOIN temp_owners o ON p.Zip = o.Zip AND p.Country = o.Country AND p.OwnerName = o.Name 
                WHERE p.PetId = 1
                AND p.OwnerID IS NULL;
                UPDATE p 
                SET OwnerID = o.OwnerID 
                FROM temp_pets p 
                INNER JOIN temp_owners o ON p.Country = o.Country AND p.OwnerName = o.Name 
                WHERE p.PetId = 1
                AND p.OwnerID IS NULL;
                UPDATE p 
                SET OwnerID = o.OwnerID 
                FROM temp_pets p 
                INNER JOIN temp_owners o ON p.OwnerName = o.Name 
                WHERE p.PetId = 1
                AND p.OwnerID IS NULL;
                UPDATE p 
                SET OwnerID = o.OwnerID 
                FROM temp_pets p 
                INNER JOIN temp_owners o ON p.Zip = o.Zip AND p.OwnerName = o.Name AND p.Document = o.Document 
                WHERE p.PetId = 2
                AND p.OwnerID IS NULL;
                UPDATE p 
                SET OwnerID = o.OwnerID 
                FROM temp_pets p 
                INNER JOIN temp_owners o ON p.OwnerName = o.Name AND p.Document = o.Document 
                WHERE p.PetId = 2
                AND p.OwnerID IS NULL;
                UPDATE p 
                SET OwnerID = o.OwnerID 
                FROM temp_pets p 
                INNER JOIN temp_owners o ON p.Document = o.Document 
                WHERE p.PetId = 2
                AND p.OwnerID IS NULL;
                UPDATE p 
                SET OwnerID = o.OwnerID 
                FROM temp_pets p 
                INNER JOIN temp_owners o ON p.Country = o.Country 
                WHERE p.PetId = 3
                AND p.OwnerID IS NULL;