Consulta Consecutivo

William Garcia,

Trata:

update document
set docnroprei = 30162 + (
select
count(*)
from
document as d
where
d.docnro >= 30162 and d.docnro <= 30174
and d.docnro <= document.docnro
)
where docnro >= 30162 and docnro <= 30174

;with r_set
as
(
select docnro , docnroprei, row_number() over(order by docnro) as rn
from document
where docnro >= 30162 and docnro <= 30174
)
update r_set
set docnroprei = 30162 + rn;


AMB


"William Garcia" wrote:

Buen dia

Quiero tener renumerar pero tengo la siguiente consulta y me deja siempre el
mismo numero 30163

update document
set docnroprei 0162+1
where docnro>0162 and docnro<0174
go


le agradezco su colaboracion

William Garcia