clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 818539 fiddles created (9194 in the last week).

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)
 hidden batch(es)