SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (id int identity, status varchar(100));
create table audit(id int, old_status varchar(100), new_status varchar(100), updated_at datetime);
create trigger StatusUpdate
on t
After UPDATE as

if (update(status) 
       and exists(select * from inserted i 
                  inner join deleted d on d.id = i.id
                  where d.status != 'Executed' 
                  and i.status = 'Executed'))
begin
insert into audit (id, old_status, new_status, updated_at)
  select i.id, d.status, i.status, getdate() 
  from inserted i 
  inner join deleted d on d.id = i.id
  where d.status != 'Executed' 
  and i.status = 'Executed'
end
insert t (status) select 'Draft';
insert t (status) select 'Pending';
update t set status = 'Executed';
update t set status = 'Executed';
8 rows affected

select * from audit;


id
old_status
new_status
updated_at


2
Pending
Executed
2024-05-09 03:27:32.260

1
Draft
Executed
2024-05-09 03:27:32.260

id	old_status	new_status	updated_at
2	Pending	Executed	2024-05-09 03:27:32.260
1	Draft	Executed	2024-05-09 03:27:32.260