By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;
CREATE TABLE [dbo].[runners](
[runid] [varchar](8) NULL,
[year] [smallint] NULL,
[start] [numeric](5, 3) NULL,
[end] [numeric](5, 3) NULL,
[road] [varchar](2) NULL
) ON [PRIMARY]
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(0.000 AS Numeric(5, 3)), CAST(0.585 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(0.000 AS Numeric(5, 3)), CAST(7.777 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(0.585 AS Numeric(5, 3)), CAST(4.980 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(4.980 AS Numeric(5, 3)), CAST(7.777 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(7.777 AS Numeric(5, 3)), CAST(11.857 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(7.777 AS Numeric(5, 3)), CAST(11.857 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(11.857 AS Numeric(5, 3)), CAST(13.274 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(11.857 AS Numeric(5, 3)), CAST(13.274 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(15.235 AS Numeric(5, 3)), CAST(21.021 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(15.235 AS Numeric(5, 3)), CAST(21.021 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(21.021 AS Numeric(5, 3)), CAST(22.142 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(21.021 AS Numeric(5, 3)), CAST(22.142 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(22.142 AS Numeric(5, 3)), CAST(25.946 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(22.142 AS Numeric(5, 3)), CAST(25.946 AS Numeric(5, 3)), N'3')
| (No column name) |
|---|
| Microsoft SQL Server 2016 (SP2-CU2) (KB4340355) - 13.0.5153.0 (X64) Jun 28 2018 17:24:28 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) |