--select * into Trade2018 from Aozzo_ODS..Trade t1

--where t1.Created<'2019-01-01'

--创建索引

--create index ix_Trade2018_created on Trade2018 (Created)

DECLARE @totalPage int --总页数

DECLARE @pageSize INT=1000

DECLARE @pageIndex INT=1

--var totalPage = (total + pageSize - 1)/pageSize;

select @totalPage=(count(1)+@pageSize-1)/@pageSize from Trade2018

print @totalPage

while (@pageIndex<=@totalPage)

begin

delete  Aozzo_ODS..Trade where tid in (

SELECT tid FROM

(

    SELECT ROW_NUMBER() OVER (ORDER BY Created ASC) AS 'RowNumber', * FROM dbo.Trade2018

) AS tb

WHERE RowNumber BETWEEN ( ( ( @pageIndex - 1 ) * @pageSize ) + 1 ) AND ( @pageIndex * @pageSize )

)

SET @pageIndex = @pageIndex+1

end

/*

select t1.* into TradeItem2018 from Aozzo_ODS..TradeItem t1

where t1.PayTime<'2019-01-01'

create index ix_TradeItem2018_created on TradeItem2018 (paytime)

select   t1.*  into  TradeItem2018_temp from Aozzo_ODS..TradeItem t1

inner join trade2018 t2

on t1.Tid=t2.tid

*/