Select Code to Download

select ... from big_table limit 1000000, 1000010

set rowcount 10010
select pk, id = syb_identity(10) into #tmp from big_table where some_c
+ondition
...
 where t.pk = b.pk
   and t.id >= 10000
set rowcount 0