add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name)
Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64)
Jul 25 2020 11:26:55
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
15 rows affected
yyyymmdd period country cat1 cat2 cat3 score
2019-12-01 A US Sports Cycle long 33
2019-12-01 A US Sports Cycle Short 35
2019-12-01 A US Sports Running long 28
2019-12-01 A US Sports Running short 29
2019-12-01 A US Arts null null null
2019-12-02 A US Sports Cycle long 43
2019-12-02 A US Sports Cycle Short 44
2019-12-02 A US Sports Running long 35
2019-12-02 A US Sports Running short 37
2019-12-02 A US Arts null null null
2020-12-01 B US Sports Cycle long 33
2020-12-01 B US Sports Cycle Short 35
2020-12-01 B US Sports Running long 28
2020-12-01 B US Sports Running short 29
2020-12-01 B US Arts null null null
yyyymmdd period country cat1 cat2 cat3 score score_day1
2019-12-01 A US Sports Cycle long 33 33
2019-12-01 A US Sports Cycle Short 35 35
2019-12-01 A US Sports Running long 28 28
2019-12-01 A US Sports Running short 29 29
2019-12-01 A US Arts null null null null
2019-12-02 A US Sports Cycle long 43 33
2019-12-02 A US Sports Cycle Short 44 35
2019-12-02 A US Sports Running long 35 28
2019-12-02 A US Sports Running short 37 29
2019-12-02 A US Arts null null null null
2020-12-01 B US Sports Cycle long 33 33
2020-12-01 B US Sports Cycle Short 35 35
2020-12-01 B US Sports Running long 28 28
2020-12-01 B US Sports Running short 29 29
2020-12-01 B US Arts null null null null