selet * into #temp from table1 order by field1
alter table #temp add newfield int identity(1,1)
truncate table table1
alter table table1 add newfield int identity(1,1)
insert table1 (field1,field2) select field1,field2 from #temp
update table1 set field2=a.field1 from #temp a where a.newfield+1=table1.newfield
alter table table1 drop column newfield
alter table #temp add newfield int identity(1,1)
truncate table table1
alter table table1 add newfield int identity(1,1)
insert table1 (field1,field2) select field1,field2 from #temp
update table1 set field2=a.field1 from #temp a where a.newfield+1=table1.newfield
alter table table1 drop column newfield
a.newfield-1=table1.newfield alter table table1 drop column newfield
from table1 a
from table1 a