add
remove
language
chart
show hidden
hide
db<>fiddle
Db2
DocumentDB
DuckDB
Firebird
MariaDB
MySQL
Oracle
Postgres
SQL Server
SQLite
TimescaleDB
YugabyteDB
11.1
11.5
12.1
0.114 (MongoDB 7.0)
0.116 (MongoDB 7.0)
1.4 LTS
3.0
4.0
5.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
10.11
11.4
11.8
12.3
5.5
5.6
5.7
8.0
8.4
9.7
11g Release 2
18c
21c
23c
23ai
26ai
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
17
18
19 beta 4
2012
2014
2016
2017 (Linux)
2017
2019 (Linux)
2019
2022
2025
3.8
3.16
3.27
3.39
3.45
3.53
2.11
2.14
2.28
2.6
2.8
2.18
2024.2 LTS
2025.2 LTS
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
Sakila
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
HR
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
db<>fiddle Statistics
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
AdventureWorks
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
run with 2025
abort
markdown
clear
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
CREATE TABLE [dbo].[sample_transition_data]( [SerialNumber] [int] NOT NULL, [Time] [datetime] NOT NULL, [event_transition] [varchar](5) NOT NULL, [duration_secs] [int] NULL ) ON [PRIMARY] INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-07T06:28:31.000' AS DateTime), N'True', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-07T06:28:47.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-07T06:28:52.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-07T09:10:54.000' AS DateTime), N'True', 9743) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-07T16:50:38.000' AS DateTime), N'True', 37327) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-07T16:50:59.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-07T16:51:02.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:04:06.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:04:07.000' AS DateTime), N'True', 84936) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:04:09.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:04:09.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:04:09.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:04:11.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:24:11.000' AS DateTime), N'True', 86140) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:25:19.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:25:20.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:25:26.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:25:26.000' AS DateTime), N'True', 86215) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:25:28.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:25:29.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:25:31.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:25:31.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T06:25:41.000' AS DateTime), N'True', 86230) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T07:41:16.000' AS DateTime), N'True', 90765) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T11:40:34.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T11:41:32.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T13:20:32.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T13:20:33.000' AS DateTime), N'True', 111122) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T13:20:33.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-08T13:20:33.000' AS DateTime), N'True', 111122) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:03.000' AS DateTime), N'True', 172352) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:38.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:38.000' AS DateTime), N'True', 172387) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:39.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:39.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:42.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:46.000' AS DateTime), N'True', 172395) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:52.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:56.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:21:57.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T06:22:05.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T07:54:58.000' AS DateTime), N'True', 177987) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T09:42:16.000' AS DateTime), N'True', 184425) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T09:42:18.000' AS DateTime), N'True', 184427) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T11:15:50.000' AS DateTime), N'True', 190039) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T11:15:50.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T11:15:52.000' AS DateTime), N'True', 190041) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T13:08:11.000' AS DateTime), N'True', 196780) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T13:08:12.000' AS DateTime), N'True', 196781) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T13:08:12.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T13:08:13.000' AS DateTime), N'True', 196782) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T13:08:15.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T13:08:16.000' AS DateTime), N'True', 196785) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:27:58.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:27:58.000' AS DateTime), N'True', 201567) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:02.000' AS DateTime), N'True', 201571) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:08.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:08.000' AS DateTime), N'True', 201577) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:11.000' AS DateTime), N'True', 201580) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:11.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:13.000' AS DateTime), N'True', 201582) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:14.000' AS DateTime), N'True', 201583) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:21.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:21.000' AS DateTime), N'True', 201590) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:23.000' AS DateTime), N'True', 201592) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:23.000' AS DateTime), N'True', 201592) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:25.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:27.000' AS DateTime), N'True', 201596) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:34.000' AS DateTime), N'True', 201603) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:34.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:35.000' AS DateTime), N'True', 201604) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:36.000' AS DateTime), N'True', 201605) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:37.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:39.000' AS DateTime), N'True', 201608) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:46.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:46.000' AS DateTime), N'True', 201615) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:49.000' AS DateTime), N'True', 201618) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:54.000' AS DateTime), N'True', 201623) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:54.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:28:58.000' AS DateTime), N'True', 201627) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:08.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:08.000' AS DateTime), N'True', 201637) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:14.000' AS DateTime), N'True', 201643) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:15.000' AS DateTime), N'True', 201644) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:16.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:19.000' AS DateTime), N'True', 201648) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:29.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:29.000' AS DateTime), N'True', 201658) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:30.000' AS DateTime), N'True', 201659) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:31.000' AS DateTime), N'True', 201660) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:32.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:29:38.000' AS DateTime), N'True', 201667) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:31:53.000' AS DateTime), N'True', 201802) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:31:53.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:31:57.000' AS DateTime), N'True', 201806) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:10.000' AS DateTime), N'True', 201819) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:11.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:15.000' AS DateTime), N'True', 201824) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:15.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:17.000' AS DateTime), N'True', 201826) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:18.000' AS DateTime), N'True', 201827) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:27.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:27.000' AS DateTime), N'True', 201836) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:32.000' AS DateTime), N'True', 201841) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:33.000' AS DateTime), N'True', 201842) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:34.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:35.000' AS DateTime), N'True', 201844) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:39.000' AS DateTime), N'False', 0) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:39.000' AS DateTime), N'True', 201848) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T14:32:40.000' AS DateTime), N'True', 201849) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T15:03:58.000' AS DateTime), N'True', 203727) INSERT [dbo].[sample_transition_data] ([SerialNumber], [Time], [event_transition], [duration_secs]) VALUES (748946, CAST(N'2020-10-09T15:06:27.000' AS DateTime), N'True', 203876)
112 rows affected