declare local temporary table TrecingRecord_day (
				[minTrackingRecordID]	bigint	NOT NULL,
				[maxTrackingRecordID]	bigint	NOT NULL,
                [Stamp]					date	NOT NULL,
  )on commit preserve rows;



insert into TrecingRecord_day
select 
 min(TrackingRecordID) as minTrackingRecordID
,max(TrackingRecordID) as maxTrackingRecordID
,cast(Stamp as date) as stampe
from dfc.tb_lr_gpapp_TrackingRecord
where cast(stamp as date) <'2016-06-05'
group by cast(stamp as date)
order by 3;


BEGIN

     declare trecing_cursor  cursor for
     select minTrackingRecordID, maxTrackingRecordID
     from TrecingRecord_day
     order by minTrackingRecordID FOR READ ONLY
    
     declare @startid bigint
     declare @endid bigint
    
     open trecing_cursor
    
         fetch  trecing_cursor into @startid, @endid
        
        WHILE @@FETCH_STATUS = 0
        
                BEGIN

                insert into testing 
                values(@startid, @endid)


                END
     CLOSE trecing_cursor
     DEALLOCATE trecing_cursor
END