create table tabela2 (campo1 int, campo2 date, campo3 varchar(1));

insert into tabela1 (campo1, campo2, campo3) values

(959, '2023-03-17', 'G'),

(959, '2023-03-18', 'G'),

(959, '2023-03-19', 'G'),

(970, '2023-03-15', 'G'),

(970, '2023-03-17', 'G');

insert into tabela2 (campo1, campo2, campo3) values

(959, '2023-03-17', 'G'),

(959, '2023-03-18', 'G'),

(959, '2023-03-19', 'G'),

(970, '2023-03-15', 'G'),

(970, '2023-03-17', 'G');

select 'antes do resultado' ;

select campo1, campo2, campo3 from tabela1;

select campo1, campo2, campo3 from tabela2;

Select Campo1, Max(campo2) as UltimaData into #tmp From Tabela1 Group By Campo1;

select * from #tmp

select row_number() over (order by campo1, ultimadata) linha, campo1, ultimadata into #tmpTabela from #tmp

select 'registros selecionados à serem alterados'

select * from #tmpTabela;

declare @linha int;

set @linha = 1;

declare @campo1Var int;