CREATE TABLE #old_table (
[Route] Nvarchar(100),
ELR char(3),
TrackID int,
StartMiles int,
StartYards int,
EndMiles int,
EndYards int,
LengthofSection INT
)
TRUNCATE TABLE #old_table
INSERT INTO #old_table SELECT 'Western West', 'ABW', 1100, 0, 117, 0, 220, 103
INSERT INTO #old_table SELECT 'Western West', 'ABW', 1100, 0, 220, 0, 440, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 1100, 0, 440, 0, 660, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 1100, 0, 660, 0, 880, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 1100, 0, 880, 0,1100, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 1100, 0, 1100, 0, 1320, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 1100, 0, 1320, 0, 1399, 79
INSERT INTO #old_table SELECT 'Western West', 'ABW', 2100, 0, 117, 0, 220, 103
INSERT INTO #old_table SELECT 'Western West', 'ABW', 2100, 0, 220, 0, 440, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 2100, 0, 440, 0, 660, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 2100, 0, 660, 0, 880, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 2100, 0, 880, 0, 1100, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 2100, 0, 1100, 0, 1320, 220
INSERT INTO #old_table SELECT 'Western West', 'ABW', 2100, 0, 1320, 0, 1399, 79