Insert data. Do until

4

--script to create the sample data

CREATE TABLE #old_table (
    TME varchar(100),
    TSM varchar(100),
    ELR char(3),
    TrackID int,
    StartMiles int,
    StartYards int,
    EndMiles int,
    EndYards int
    )
TRUNCATE TABLE #old_table
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 29, 110, 29, 220
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 29, 220, 29, 440
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 29, 440, 29, 660
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 29, 660, 29, 880
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 29, 880, 29,1100
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 29,1100, 29,1320
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 29,1320, 29,1540
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 29,1540, 30,   0
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 30,   0, 30, 220
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 30, 220, 30, 440
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 30, 440, 30, 660
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 30, 660, 30, 880
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 30, 880, 30,1100
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 30,1100, 30,1320
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 30,1320, 31,   0
INSERT INTO #old_table SELECT 'TME Feltham', 'TSM Feltham', 'AAV', 1100, 31,   0, 31, 220