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
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