Consulta complicada

[iislas]

Bueno, entonces, digame si le funciona el siguiente query

create table #paso (folio varchar(50) primary key)
insert into #paso
select folio from tutabla
declare @folio varchar(50)
declare @consecutivo int
declare @numpagina int
set @consecutivo = 1
set @consecutivo = 1
while exists(select folio from #paso)
begin
select top 1 @folio = folio from tutabla order by folio
update tutabla set consecutivo = @consecutivo, numpagina = @numpagina
where folio = @folio
delete #paso where folio = @folio
set @consecutivo = @consecutivo + 1
set @numpagina = @numpagina + 1
if @numpagina > 7500
set @numpagina = 1
continue
end