Count

DECLARE @i INT 
set @i=300000
INSERT INTO TEMP_2
(
pkg,
closeday,
Segment,
CloseDayType,
eid ,
edate,
active,
modifier,
modifyDate,
CloseType,
StartCity
)
SELECT 
pkg,
closeday,
Segment,
CloseDayType,
eid ,
edate,
active,
modifier,
modifyDate,
CloseType,
StartCity
FROM Temp_1   where px<=@i
while @@rowcount >0
begin 
  set @i=@i+300000
 INSERT INTO Temp_2  
(
pkg,
closeday,
Segment,
CloseDayType,
eid ,
edate,
active,
modifier,
modifyDate,
CloseType,
StartCity
)
SELECT 
pkg,
closeday,
Segment,
CloseDayType,
eid ,
edate,
active,
modifier,
modifyDate,
CloseType,
StartCity
FROM Temp_1  where px<=@i and px>@i-300000
END