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.
select @@version;
(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)
CREATE TABLE t_dataset_sample
(
Top_level_article varchar(300),
Prev_article varchar(300),
Current_Article varchar(300),
Quantity varchar(300),
Level varchar(300),
Ord varchar(300)
);

INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80542.296', '80542.296', '1', '0', '80542.296');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80542.296', '80537.127', '1', '1', '80542.296 ||80537.127');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80542.296', '80537.969', '1', '1', '80542.296 ||80537.969');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80542.296', '80540.285', '1', '1', '80542.296 ||80540.285');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.285', '01583.1527-H', '1', '2', '80542.296 ||80540.285||01583.1527-H');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.285', '80539.398', '1', '2', '80542.296 ||80540.285||80539.398');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.285', '80540.05', '1', '2', '80542.296 ||80540.285||80540.050');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.05', '80540.050U', '1', '3', '80542.296 ||80540.285||80540.050||80540.050U');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.050U', '80540.092', '0.001', '4', '80542.296 ||80540.285||80540.050||80540.050U||80540.092');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.092', '80532.395', '0.023', '5', '80542.296 ||80540.285||80540.050||80540.050U||80540.092||80532.395');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80542.296', '80540.296', '1', '1', '80542.296 ||80540.296');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80542.296', '80540.95', '1', '1', '80542.296 ||80540.950');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80542.296', '80542.297', '1', '1', '80542.296 ||80542.297');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80542.297', '80540.284', '1', '2', '80542.296 ||80542.297||80540.284');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.284', '80540.552U', '1', '3', '80542.296 ||80542.297||80540.284||80540.552U');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.552U', '80540.552I', '1', '4', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.552I', '80539.866', '0.0957', '5', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80539.866', '55999.037', '0.8608', '6', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||55999.037');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80539.866', '80535.87', '0.0153', '6', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||80535.870');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80539.866', '80535.871', '0.0408', '6', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||80535.871');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80539.866', '80535.872', '0.0113', '6', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||80535.872');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80539.866', '98999.028', '0.0387', '6', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||98999.028');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80539.866', '98999.029', '0.0061', '6', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||98999.029');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80539.866', '98999.03', '0.0092', '6', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||98999.030');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80539.866', '98999.031', '0.0178', '6', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||98999.031');
INSERT INTO t_dataset_sample (Top_level_article,Prev_article,Current_Article,Quantity,Level,Ord) VALUES ('80542.296', '80540.552I', '80539.999', '0.0957', '5', '80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.999');
121 rows affected
select * from t_dataset_sample
Top_level_article Prev_article Current_Article Quantity Level Ord
80542.296 80542.296 80542.296 1 0 80542.296
80542.296 80542.296 80537.127 1 1 80542.296 ||80537.127
80542.296 80542.296 80537.969 1 1 80542.296 ||80537.969
80542.296 80542.296 80540.285 1 1 80542.296 ||80540.285
80542.296 80540.285 01583.1527-H 1 2 80542.296 ||80540.285||01583.1527-H
80542.296 80540.285 80539.398 1 2 80542.296 ||80540.285||80539.398
80542.296 80540.285 80540.05 1 2 80542.296 ||80540.285||80540.050
80542.296 80540.05 80540.050U 1 3 80542.296 ||80540.285||80540.050||80540.050U
80542.296 80540.050U 80540.092 0.001 4 80542.296 ||80540.285||80540.050||80540.050U||80540.092
80542.296 80540.092 80532.395 0.023 5 80542.296 ||80540.285||80540.050||80540.050U||80540.092||80532.395
80542.296 80542.296 80540.296 1 1 80542.296 ||80540.296
80542.296 80542.296 80540.95 1 1 80542.296 ||80540.950
80542.296 80542.296 80542.297 1 1 80542.296 ||80542.297
80542.296 80542.297 80540.284 1 2 80542.296 ||80542.297||80540.284
80542.296 80540.284 80540.552U 1 3 80542.296 ||80542.297||80540.284||80540.552U
80542.296 80540.552U 80540.552I 1 4 80542.296 ||80542.297||80540.284||80540.552U||80540.552I
80542.296 80540.552I 80539.866 0.0957 5 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866
80542.296 80539.866 55999.037 0.8608 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||55999.037
80542.296 80539.866 80535.87 0.0153 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||80535.870
80542.296 80539.866 80535.871 0.0408 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||80535.871
80542.296 80539.866 80535.872 0.0113 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||80535.872
80542.296 80539.866 98999.028 0.0387 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||98999.028
80542.296 80539.866 98999.029 0.0061 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||98999.029
80542.296 80539.866 98999.03 0.0092 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||98999.030
80542.296 80539.866 98999.031 0.0178 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.866||98999.031
80542.296 80540.552I 80539.999 0.0957 5 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||80539.999
80542.296 80540.552I I-1689 0.0002 5 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689
80542.296 I-1689 CAR-0001 1 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001
80542.296 CAR-0001 CAR-0001-01 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01
80542.296 CAR-0001-01 CAR-0001-AT301 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-AT301
80542.296 CAR-0001-01 CAR-0001-CJ321 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-CJ321
80542.296 CAR-0001-01 CAR-0001-PE302 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-PE302
80542.296 CAR-0001-01 CAR-0001-PF301 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-PF301
80542.296 CAR-0001-01 CAR-0001-PL331 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-PL331
80542.296 CAR-0001-01 CAR-0001-PL335 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-PL335
80542.296 CAR-0001-01 CAR-0001-PL336 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-PL336
80542.296 CAR-0001-01 CAR-0001-PL337 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-PL337
80542.296 CAR-0001-01 CAR-0001-PM310 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-PM310
80542.296 CAR-0001-01 CAR-0001-SM313 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-SM313
80542.296 CAR-0001-01 CAR-0001-TA312 1 8 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||CAR-0001||CAR-0001-01||CAR-0001-TA312
80542.296 I-1689 I-1689-AEMC 1 6 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC
80542.296 I-1689-AEMC I-1689-EC200 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-EC200
80542.296 I-1689-AEMC I-1689-EF100 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-EF100
80542.296 I-1689-AEMC I-1689-EJ200 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-EJ200
80542.296 I-1689-AEMC I-1689-EJ201 11 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-EJ201
80542.296 I-1689-AEMC I-1689-EJ202 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-EJ202
80542.296 I-1689-AEMC I-1689-EM200 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-EM200
80542.296 I-1689-AEMC I-1689-IE200 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-IE200
80542.296 I-1689-AEMC I-1689-IN200 2 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-IN200
80542.296 I-1689-AEMC I-1689-NO200 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-NO200
80542.296 I-1689-AEMC I-1689-PU200 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-PU200
80542.296 I-1689-AEMC I-1689-TR200 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-TR200
80542.296 I-1689-AEMC I-1689-TR201 1 7 80542.296 ||80542.297||80540.284||80540.552U||80540.552I||I-1689||I-1689-AEMC||I-1689-TR201
80542.296 80542.297 80542 1 2 80542.296 ||80542.297||80542.000
80542.296 80542.297 80542.349 1 2 80542.296 ||80542.297||80542.349
80542.296 80542.349 80542.348 1 3 80542.296 ||80542.297||80542.349||80542.348
80542.296 80542.348 80540.289I 1 4 80542.296 ||80542.297||80542.349||80542.348||80540.289I
80542.296 80540.289I 80530.005 0.0027 5 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80530.005
80542.296 80540.289I 80539.866 0.0014 5 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.866
80542.296 80539.866 55999.037 0.8608 6 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.866||55999.037
80542.296 80539.866 80535.87 0.0153 6 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.866||80535.870
80542.296 80539.866 80535.871 0.0408 6 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.866||80535.871
80542.296 80539.866 80535.872 0.0113 6 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.866||80535.872
80542.296 80539.866 98999.028 0.0387 6 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.866||98999.028
80542.296 80539.866 98999.029 0.0061 6 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.866||98999.029
80542.296 80539.866 98999.03 0.0092 6 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.866||98999.030
80542.296 80539.866 98999.031 0.0178 6 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.866||98999.031
80542.296 80540.289I 80539.999 0.0041 5 80542.296 ||80542.297||80542.349||80542.348||80540.289I||80539.999
80542.296 80540.289I I-1697 0.0002 5 80542.296 ||80542.297||80542.349||80542.348||80540.289I||I-1697
80542.296 80542.297 80543.653 1 2 80542.296 ||80542.297||80543.653
80542.296 80542.297 AA571.1228 1 2 80542.296 ||80542.297||AA571.1228
80542.296 AA571.1228 1571.1228 1 3 80542.296 ||80542.297||AA571.1228||01571.1228
80542.296 1571.1228 0.005 0.95 4 80542.296 ||80542.297||AA571.1228||01571.1228||00000.005
80542.296 1571.1228 02571.1228-H 1 4 80542.296 ||80542.297||AA571.1228||01571.1228||02571.1228-H
80542.296 80542.296 80542.298 1 1 80542.296 ||80542.298
80542.296 80542.298 80542.35 1 2 80542.296 ||80542.298||80542.350
80542.296 80542.35 80542.350U 1 3 80542.296 ||80542.298||80542.350||80542.350U
80542.296 80542.350U 80542.350I 1 4 80542.296 ||80542.298||80542.350||80542.350U||80542.350I
80542.296 80542.350I 80530.005 0.0024 5 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80530.005
80542.296 80542.350I 80539.866 0.0334 5 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.866
80542.296 80539.866 55999.037 0.8608 6 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.866||55999.037
80542.296 80539.866 80535.87 0.0153 6 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.866||80535.870
80542.296 80539.866 80535.871 0.0408 6 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.866||80535.871
80542.296 80539.866 80535.872 0.0113 6 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.866||80535.872
80542.296 80539.866 98999.028 0.0387 6 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.866||98999.028
80542.296 80539.866 98999.029 0.0061 6 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.866||98999.029
80542.296 80539.866 98999.03 0.0092 6 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.866||98999.030
80542.296 80539.866 98999.031 0.0178 6 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.866||98999.031
80542.296 80542.350I 80539.999 0.0358 5 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||80539.999
80542.296 80542.350I I-1804 0.0002 5 80542.296 ||80542.298||80542.350||80542.350U||80542.350I||I-1804
80542.296 80542.298 80542.351 1 2 80542.296 ||80542.298||80542.351
80542.296 80542.351 80542.351I 1 3 80542.296 ||80542.298||80542.351||80542.351I
80542.296 80542.351I 80539.866 0.0298 4 80542.296 ||80542.298||80542.351||80542.351I||80539.866
80542.296 80539.866 55999.037 0.8608 5 80542.296 ||80542.298||80542.351||80542.351I||80539.866||55999.037
80542.296 80539.866 80535.87 0.0153 5 80542.296 ||80542.298||80542.351||80542.351I||80539.866||80535.870
80542.296 80539.866 80535.871 0.0408 5 80542.296 ||80542.298||80542.351||80542.351I||80539.866||80535.871
80542.296 80539.866 80535.872 0.0113 5 80542.296 ||80542.298||80542.351||80542.351I||80539.866||80535.872
80542.296 80539.866 98999.028 0.0387 5 80542.296 ||80542.298||80542.351||80542.351I||80539.866||98999.028
80542.296 80539.866 98999.029 0.0061 5 80542.296 ||80542.298||80542.351||80542.351I||80539.866||98999.029
80542.296 80539.866 98999.03 0.0092 5 80542.296 ||80542.298||80542.351||80542.351I||80539.866||98999.030
80542.296 80539.866 98999.031 0.0178 5 80542.296 ||80542.298||80542.351||80542.351I||80539.866||98999.031
80542.296 80542.351I 80539.999 0.0298 4 80542.296 ||80542.298||80542.351||80542.351I||80539.999
80542.296 80542.351I I-1805 0.0002 4 80542.296 ||80542.298||80542.351||80542.351I||I-1805
80542.296 80542.298 80542.411 1 2 80542.296 ||80542.298||80542.411
80542.296 80542.298 80542.412 1 2 80542.296 ||80542.298||80542.412
80542.296 80542.296 80542.299 1 1 80542.296 ||80542.299
80542.296 80542.299 80542.347 1 2 80542.296 ||80542.299||80542.347
80542.296 80542.347 80540.286I 1 3 80542.296 ||80542.299||80542.347||80540.286I
80542.296 80540.286I 80530.005 0.0027 4 80542.296 ||80542.299||80542.347||80540.286I||80530.005
80542.296 80540.286I 80539.866 0.0014 4 80542.296 ||80542.299||80542.347||80540.286I||80539.866
80542.296 80539.866 55999.037 0.8608 5 80542.296 ||80542.299||80542.347||80540.286I||80539.866||55999.037
80542.296 80539.866 80535.87 0.0153 5 80542.296 ||80542.299||80542.347||80540.286I||80539.866||80535.870
80542.296 80539.866 80535.871 0.0408 5 80542.296 ||80542.299||80542.347||80540.286I||80539.866||80535.871
80542.296 80539.866 80535.872 0.0113 5 80542.296 ||80542.299||80542.347||80540.286I||80539.866||80535.872
80542.296 80539.866 98999.028 0.0387 5 80542.296 ||80542.299||80542.347||80540.286I||80539.866||98999.028
80542.296 80539.866 98999.029 0.0061 5 80542.296 ||80542.299||80542.347||80540.286I||80539.866||98999.029
80542.296 80539.866 98999.03 0.0092 5 80542.296 ||80542.299||80542.347||80540.286I||80539.866||98999.030
80542.296 80539.866 98999.031 0.0178 5 80542.296 ||80542.299||80542.347||80540.286I||80539.866||98999.031
80542.296 80540.286I 80539.999 0.0041 4 80542.296 ||80542.299||80542.347||80540.286I||80539.999
80542.296 80540.286I I-1696 0.0002 4 80542.296 ||80542.299||80542.347||80540.286I||I-1696
80542.296 80542.296 80543.215 1 1 80542.296 ||80543.215