| ID | Name | LastName | IsActive |
-----------------------------------
| 1  | Alex | Black    | True     |
| 2  | Bob  | White    | True     | 
| 3  | Tom  | Brown    | True     |
| 4  | Bob  | White    | True     |
| 5  | Alex | Black    | True     |

| ID | Name | LastName | IsActive |
-----------------------------------
| 1  | Alex | Black    | True     |
| 5  | Alex | Black    | True     |
-----------------------------------
| 2  | Bob  | White    | True     | 
| 4  | Bob  | White    | True     |
-----------------------------------
| 3  | Tom  | Brown    | True     |

| ID | Address|

update T
set IsActive = false
where exists (select 1 from T t1 inner join Address a on t1.ID=a.ID where T.Name=t1.Name and T.LastName=t1.LastName )

declare @t table (id int, Name varchar(30), LastName varchar(30), IsActive varchar(5));
declare @a table (id int, Addr varchar(100));

insert into @t
values
(1, 'Alex', 'Black', 'True'),
(2, 'Bob', 'White', 'True'),
(3, 'Tom', 'Brown', 'True'),
(4, 'Bob', 'White', 'True'),
(5, 'Alex', 'Black', 'True');

insert into @a
values
 (1, 'aadr1'),
 (4, 'aadr2');

with x as
(
 select
  t.IsActive,
  row_number() over (partition by Name, LastName order by case when a.id is null then 1 end, a.id) as rn
 from
  @t t left join
  @a a on a.id = t.id
)
update x set IsActive = 'False' where rn > 1;

select * from @t;

| ID | Phone |

create view AttributesExistenceWithPriority
as
select
 ID, 1 as Priority
from
 Phones

union all

select
 ID, 2 as Priority
from
 Addresses;

with x as
(
 select
  t.IsActive,
  dense_rank() over (partition by Name, LastName order by case when a.Priority is null then 1 end, a.Priority, a.id) as r
 from
  Таблица t outer apply
  (select top (1) id, Priority from AttributesExistenceWithPriority where id = t.id order by Priority) a
)
update x set IsActive = 'False' where r > 1;