Created
September 26, 2018 15:18
-
-
Save pattertall/2875082fe045c90b253c24a954d4f6fc to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- This error reproduces on SQL Server 2016, 2017, and 2019 CTP | |
| SELECT @@VERSION | |
| --Microsoft SQL Server 2017 (RTM-CU9-GDR) (KB4293805) - 14.0.3035.2 (X64) | |
| -- Jul 6 2018 18:24:36 | |
| -- Copyright (C) 2017 Microsoft Corporation | |
| -- Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor) | |
| GO | |
| DROP TABLE IF EXISTS #t | |
| GO | |
| CREATE TABLE #t ( | |
| a BIGINT NOT NULL, | |
| p INT NOT NULL, | |
| s INT NOT NULL, | |
| v INT NOT NULL, | |
| m INT NOT NULL, | |
| n FLOAT NULL, | |
| INDEX CCI CLUSTERED COLUMNSTORE | |
| ) | |
| GO | |
| INSERT INTO #t VALUES (1,0,3761,16,1,1) | |
| INSERT INTO #t VALUES (1,0,3761,17,1,1) | |
| INSERT INTO #t VALUES (1,0,3761,18,1,1) | |
| INSERT INTO #t VALUES (1,0,3761,59,1,4) | |
| INSERT INTO #t VALUES (1,1,3761,16,1,1) | |
| INSERT INTO #t VALUES (1,1,3761,17,1,6) | |
| INSERT INTO #t VALUES (1,1,3761,18,1,6) | |
| INSERT INTO #t VALUES (1,1,3761,59,1,0) | |
| INSERT INTO #t VALUES (1,2,3761,16,1,0) | |
| INSERT INTO #t VALUES (1,2,3761,17,1,0) | |
| INSERT INTO #t VALUES (1,2,3761,18,1,2) | |
| INSERT INTO #t VALUES (1,2,3761,59,1,0) | |
| INSERT INTO #t VALUES (1,3,3761,16,1,1) | |
| INSERT INTO #t VALUES (1,3,3761,17,1,7) | |
| INSERT INTO #t VALUES (1,3,3761,18,1,7) | |
| INSERT INTO #t VALUES (1,3,3761,59,1,0) | |
| INSERT INTO #t VALUES (1,4,3761,16,1,1) | |
| INSERT INTO #t VALUES (1,4,3761,17,1,3) | |
| INSERT INTO #t VALUES (1,4,3761,18,1,3) | |
| INSERT INTO #t VALUES (1,4,3761,59,1,0) | |
| INSERT INTO #t VALUES (1,5,3761,16,1,1) | |
| INSERT INTO #t VALUES (1,5,3761,17,1,4) | |
| INSERT INTO #t VALUES (1,5,3761,18,1,4) | |
| INSERT INTO #t VALUES (1,5,3761,59,1,0) | |
| INSERT INTO #t VALUES (2,0,3761,16,1,0) | |
| INSERT INTO #t VALUES (2,0,3761,17,1,0) | |
| INSERT INTO #t VALUES (2,0,3761,18,1,7) | |
| INSERT INTO #t VALUES (2,0,3761,59,1,4) | |
| INSERT INTO #t VALUES (2,1,3761,16,1,1) | |
| INSERT INTO #t VALUES (2,1,3761,17,1,2) | |
| INSERT INTO #t VALUES (2,1,3761,18,1,2) | |
| INSERT INTO #t VALUES (2,1,3761,59,1,3) | |
| INSERT INTO #t VALUES (2,2,3761,16,1,1) | |
| INSERT INTO #t VALUES (2,2,3761,17,1,4) | |
| INSERT INTO #t VALUES (2,2,3761,18,1,4) | |
| INSERT INTO #t VALUES (2,2,3761,59,1,3) | |
| INSERT INTO #t VALUES (2,3,3761,16,1,1) | |
| INSERT INTO #t VALUES (2,3,3761,17,1,6) | |
| INSERT INTO #t VALUES (2,3,3761,18,1,6) | |
| INSERT INTO #t VALUES (2,3,3761,59,1,0) | |
| INSERT INTO #t VALUES (2,4,3761,16,1,1) | |
| INSERT INTO #t VALUES (2,4,3761,17,1,8) | |
| INSERT INTO #t VALUES (2,4,3761,18,1,8) | |
| INSERT INTO #t VALUES (2,4,3761,59,1,0) | |
| INSERT INTO #t VALUES (2,5,3761,16,1,1) | |
| INSERT INTO #t VALUES (2,5,3761,17,1,9) | |
| INSERT INTO #t VALUES (2,5,3761,18,1,9) | |
| INSERT INTO #t VALUES (2,5,3761,59,1,0) | |
| INSERT INTO #t VALUES (3,0,3761,16,1,1) | |
| INSERT INTO #t VALUES (3,0,3761,17,1,8) | |
| INSERT INTO #t VALUES (3,0,3761,18,1,8) | |
| INSERT INTO #t VALUES (3,0,3761,59,1,3) | |
| INSERT INTO #t VALUES (3,1,3761,16,1,1) | |
| INSERT INTO #t VALUES (3,1,3761,17,1,10) | |
| INSERT INTO #t VALUES (3,1,3761,18,1,10) | |
| INSERT INTO #t VALUES (3,1,3761,59,1,3) | |
| INSERT INTO #t VALUES (3,2,3761,16,1,1) | |
| INSERT INTO #t VALUES (3,2,3761,17,1,5) | |
| INSERT INTO #t VALUES (3,2,3761,18,1,5) | |
| INSERT INTO #t VALUES (3,2,3761,59,1,5) | |
| INSERT INTO #t VALUES (3,3,3761,16,1,0) | |
| INSERT INTO #t VALUES (3,3,3761,17,1,0) | |
| INSERT INTO #t VALUES (3,3,3761,18,1,4) | |
| INSERT INTO #t VALUES (3,3,3761,59,1,4) | |
| INSERT INTO #t VALUES (3,4,3761,16,1,0) | |
| INSERT INTO #t VALUES (3,4,3761,17,1,0) | |
| INSERT INTO #t VALUES (3,4,3761,18,1,3) | |
| INSERT INTO #t VALUES (3,4,3761,59,1,3) | |
| INSERT INTO #t VALUES (3,5,3761,16,1,0) | |
| INSERT INTO #t VALUES (3,5,3761,17,1,0) | |
| INSERT INTO #t VALUES (3,5,3761,18,1,2) | |
| INSERT INTO #t VALUES (3,5,3761,59,1,4) | |
| INSERT INTO #t VALUES (4,0,3761,16,1,0) | |
| INSERT INTO #t VALUES (4,0,3761,17,1,0) | |
| INSERT INTO #t VALUES (4,0,3761,18,1,6) | |
| INSERT INTO #t VALUES (4,0,3761,59,1,1) | |
| INSERT INTO #t VALUES (4,1,3761,16,1,1) | |
| INSERT INTO #t VALUES (4,1,3761,17,1,1) | |
| INSERT INTO #t VALUES (4,1,3761,18,1,1) | |
| INSERT INTO #t VALUES (4,1,3761,59,1,2) | |
| INSERT INTO #t VALUES (4,2,3761,16,1,1) | |
| INSERT INTO #t VALUES (4,2,3761,17,1,2) | |
| INSERT INTO #t VALUES (4,2,3761,18,1,2) | |
| INSERT INTO #t VALUES (4,2,3761,59,1,1) | |
| INSERT INTO #t VALUES (4,3,3761,16,1,0) | |
| INSERT INTO #t VALUES (4,3,3761,17,1,0) | |
| INSERT INTO #t VALUES (4,3,3761,18,1,6) | |
| INSERT INTO #t VALUES (4,3,3761,59,1,4) | |
| INSERT INTO #t VALUES (4,4,3761,16,1,1) | |
| INSERT INTO #t VALUES (4,4,3761,17,1,3) | |
| INSERT INTO #t VALUES (4,4,3761,18,1,3) | |
| INSERT INTO #t VALUES (4,4,3761,59,1,1) | |
| INSERT INTO #t VALUES (4,5,3761,16,1,1) | |
| INSERT INTO #t VALUES (4,5,3761,17,1,7) | |
| INSERT INTO #t VALUES (4,5,3761,18,1,7) | |
| INSERT INTO #t VALUES (4,5,3761,59,1,2) | |
| INSERT INTO #t VALUES (5,0,3761,16,1,1) | |
| INSERT INTO #t VALUES (5,0,3761,17,1,7) | |
| INSERT INTO #t VALUES (5,0,3761,18,1,7) | |
| INSERT INTO #t VALUES (5,0,3761,59,1,4) | |
| INSERT INTO #t VALUES (5,1,3761,16,1,0) | |
| INSERT INTO #t VALUES (5,1,3761,17,1,0) | |
| INSERT INTO #t VALUES (5,1,3761,18,1,9) | |
| INSERT INTO #t VALUES (5,1,3761,59,1,1) | |
| INSERT INTO #t VALUES (5,2,3761,16,1,1) | |
| INSERT INTO #t VALUES (5,2,3761,17,1,10) | |
| INSERT INTO #t VALUES (5,2,3761,18,1,10) | |
| INSERT INTO #t VALUES (5,2,3761,59,1,2) | |
| INSERT INTO #t VALUES (5,3,3761,16,1,1) | |
| INSERT INTO #t VALUES (5,3,3761,17,1,3) | |
| INSERT INTO #t VALUES (5,3,3761,18,1,3) | |
| INSERT INTO #t VALUES (5,3,3761,59,1,5) | |
| INSERT INTO #t VALUES (5,4,3761,16,1,1) | |
| INSERT INTO #t VALUES (5,4,3761,17,1,3) | |
| INSERT INTO #t VALUES (5,4,3761,18,1,3) | |
| INSERT INTO #t VALUES (5,4,3761,59,1,2) | |
| INSERT INTO #t VALUES (5,5,3761,16,1,1) | |
| INSERT INTO #t VALUES (5,5,3761,17,1,8) | |
| INSERT INTO #t VALUES (5,5,3761,18,1,8) | |
| INSERT INTO #t VALUES (5,5,3761,59,1,5) | |
| INSERT INTO #t VALUES (1,0,3761,17,2,14.8533) | |
| INSERT INTO #t VALUES (1,0,3761,18,2,7.85185) | |
| INSERT INTO #t VALUES (1,1,3761,17,2,12.52) | |
| INSERT INTO #t VALUES (1,1,3761,18,2,7.74074) | |
| INSERT INTO #t VALUES (1,2,3761,17,2,14.4) | |
| INSERT INTO #t VALUES (1,2,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (1,3,3761,17,2,14.6) | |
| INSERT INTO #t VALUES (1,3,3761,18,2,7.62963) | |
| INSERT INTO #t VALUES (1,4,3761,17,2,11.4) | |
| INSERT INTO #t VALUES (1,4,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (1,5,3761,16,2,0.309616) | |
| INSERT INTO #t VALUES (1,5,3761,17,2,16.2437) | |
| INSERT INTO #t VALUES (1,5,3761,18,2,7.88889) | |
| INSERT INTO #t VALUES (1,5,3761,59,2,3.29165) | |
| INSERT INTO #t VALUES (1,6,3761,16,2,0.807424) | |
| INSERT INTO #t VALUES (1,6,3761,17,2,12.1333) | |
| INSERT INTO #t VALUES (1,6,3761,18,2,7.18519) | |
| INSERT INTO #t VALUES (1,6,3761,59,2,0.785378) | |
| INSERT INTO #t VALUES (1,7,3761,16,2,0.396776) | |
| INSERT INTO #t VALUES (1,7,3761,17,2,12.5071) | |
| INSERT INTO #t VALUES (1,7,3761,18,2,6.92593) | |
| INSERT INTO #t VALUES (1,7,3761,59,2,3.4336) | |
| INSERT INTO #t VALUES (1,8,3761,16,2,0.589545) | |
| INSERT INTO #t VALUES (1,8,3761,17,2,13.7038) | |
| INSERT INTO #t VALUES (1,8,3761,18,2,8.66667) | |
| INSERT INTO #t VALUES (1,8,3761,59,2,0.974083) | |
| INSERT INTO #t VALUES (1,9,3761,16,2,0.232789) | |
| INSERT INTO #t VALUES (1,9,3761,17,2,14.5333) | |
| INSERT INTO #t VALUES (1,9,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (1,9,3761,59,2,2.46965) | |
| INSERT INTO #t VALUES (1,10,3761,16,2,0.926254) | |
| INSERT INTO #t VALUES (1,10,3761,17,2,9.84524) | |
| INSERT INTO #t VALUES (1,10,3761,18,2,7.28571) | |
| INSERT INTO #t VALUES (1,10,3761,59,2,2.88615) | |
| INSERT INTO #t VALUES (1,11,3761,16,2,0.364858) | |
| INSERT INTO #t VALUES (1,11,3761,17,2,11.3333) | |
| INSERT INTO #t VALUES (1,11,3761,18,2,6.80952) | |
| INSERT INTO #t VALUES (1,11,3761,59,2,2.80648) | |
| INSERT INTO #t VALUES (1,12,3761,16,2,0.804224) | |
| INSERT INTO #t VALUES (1,12,3761,17,2,10.5104) | |
| INSERT INTO #t VALUES (1,12,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (1,12,3761,59,2,2.87982) | |
| INSERT INTO #t VALUES (1,13,3761,16,2,0.982205) | |
| INSERT INTO #t VALUES (1,13,3761,17,2,9.72917) | |
| INSERT INTO #t VALUES (1,13,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (1,13,3761,59,2,2.68705) | |
| INSERT INTO #t VALUES (1,14,3761,16,2,0.931183) | |
| INSERT INTO #t VALUES (1,14,3761,17,2,11.1556) | |
| INSERT INTO #t VALUES (1,14,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (1,14,3761,59,2,1.28226) | |
| INSERT INTO #t VALUES (1,15,3761,16,2,0.943006) | |
| INSERT INTO #t VALUES (1,15,3761,17,2,15.5556) | |
| INSERT INTO #t VALUES (1,15,3761,18,2,8.44444) | |
| INSERT INTO #t VALUES (1,15,3761,59,2,3.52202) | |
| INSERT INTO #t VALUES (1,16,3761,16,2,0.546376) | |
| INSERT INTO #t VALUES (1,16,3761,17,2,11.5185) | |
| INSERT INTO #t VALUES (1,16,3761,18,2,6.94444) | |
| INSERT INTO #t VALUES (1,16,3761,59,2,1.6206) | |
| INSERT INTO #t VALUES (1,17,3761,16,2,11.9333) | |
| INSERT INTO #t VALUES (1,17,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (1,17,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (1,17,3761,59,2,5.02393) | |
| INSERT INTO #t VALUES (1,18,3761,16,2,1.14286) | |
| INSERT INTO #t VALUES (1,18,3761,17,2,22) | |
| INSERT INTO #t VALUES (1,18,3761,18,2,5.5) | |
| INSERT INTO #t VALUES (1,18,3761,59,2,4.3) | |
| INSERT INTO #t VALUES (1,19,3761,16,2,1) | |
| INSERT INTO #t VALUES (1,19,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (1,19,3761,18,2,8) | |
| INSERT INTO #t VALUES (1,19,3761,59,2,2.3) | |
| INSERT INTO #t VALUES (1,20,3761,16,2,1) | |
| INSERT INTO #t VALUES (1,20,3761,17,2,9.25) | |
| INSERT INTO #t VALUES (1,20,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (1,20,3761,59,2,2.1) | |
| INSERT INTO #t VALUES (1,21,3761,16,2,-0.142857) | |
| INSERT INTO #t VALUES (1,21,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (1,21,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (1,21,3761,59,2,5.4) | |
| INSERT INTO #t VALUES (1,22,3761,16,2,1) | |
| INSERT INTO #t VALUES (1,22,3761,17,2,11) | |
| INSERT INTO #t VALUES (1,22,3761,18,2,8.25) | |
| INSERT INTO #t VALUES (1,22,3761,59,2,3.3) | |
| INSERT INTO #t VALUES (1,23,3761,16,2,0) | |
| INSERT INTO #t VALUES (1,23,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (1,23,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (1,23,3761,59,2,4.4) | |
| INSERT INTO #t VALUES (1,24,3761,16,2,-0.142857) | |
| INSERT INTO #t VALUES (1,24,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (1,24,3761,18,2,8) | |
| INSERT INTO #t VALUES (1,24,3761,59,2,-0.2) | |
| INSERT INTO #t VALUES (1,25,3761,16,2,0) | |
| INSERT INTO #t VALUES (1,25,3761,17,2,25) | |
| INSERT INTO #t VALUES (1,25,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (1,25,3761,59,2,-1.1) | |
| INSERT INTO #t VALUES (1,26,3761,16,2,0) | |
| INSERT INTO #t VALUES (1,26,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (1,26,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (1,26,3761,59,2,-2.2) | |
| INSERT INTO #t VALUES (1,27,3761,16,2,1.14286) | |
| INSERT INTO #t VALUES (1,27,3761,17,2,22.5) | |
| INSERT INTO #t VALUES (1,27,3761,18,2,11.25) | |
| INSERT INTO #t VALUES (1,27,3761,59,2,1) | |
| INSERT INTO #t VALUES (1,28,3761,16,2,1.14286) | |
| INSERT INTO #t VALUES (1,28,3761,17,2,12) | |
| INSERT INTO #t VALUES (1,28,3761,18,2,6) | |
| INSERT INTO #t VALUES (1,28,3761,59,2,8.6) | |
| INSERT INTO #t VALUES (1,29,3761,16,2,-0.142857) | |
| INSERT INTO #t VALUES (1,29,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (1,29,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (1,29,3761,59,2,1) | |
| INSERT INTO #t VALUES (1,30,3761,16,2,1.14286) | |
| INSERT INTO #t VALUES (1,30,3761,17,2,11.5) | |
| INSERT INTO #t VALUES (1,30,3761,18,2,5.75) | |
| INSERT INTO #t VALUES (1,30,3761,59,2,4.7) | |
| INSERT INTO #t VALUES (1,31,3761,16,2,1) | |
| INSERT INTO #t VALUES (1,31,3761,17,2,8.66667) | |
| INSERT INTO #t VALUES (1,31,3761,18,2,6.5) | |
| INSERT INTO #t VALUES (1,31,3761,59,2,0.9) | |
| INSERT INTO #t VALUES (1,32,3761,16,2,1) | |
| INSERT INTO #t VALUES (1,32,3761,17,2,10.5) | |
| INSERT INTO #t VALUES (1,32,3761,18,2,10.5) | |
| INSERT INTO #t VALUES (1,32,3761,59,2,-3.4) | |
| INSERT INTO #t VALUES (1,33,3761,16,2,1.14286) | |
| INSERT INTO #t VALUES (1,33,3761,17,2,43) | |
| INSERT INTO #t VALUES (1,33,3761,18,2,10.75) | |
| INSERT INTO #t VALUES (1,33,3761,59,2,2.4) | |
| INSERT INTO #t VALUES (1,34,3761,16,2,0) | |
| INSERT INTO #t VALUES (1,34,3761,17,2,17.5) | |
| INSERT INTO #t VALUES (1,34,3761,18,2,8.75) | |
| INSERT INTO #t VALUES (1,34,3761,59,2,4.2) | |
| INSERT INTO #t VALUES (1,35,3761,16,2,-0.142857) | |
| INSERT INTO #t VALUES (1,35,3761,17,2,34) | |
| INSERT INTO #t VALUES (1,35,3761,18,2,8.5) | |
| INSERT INTO #t VALUES (1,35,3761,59,2,2.2) | |
| INSERT INTO #t VALUES (1,36,3761,16,2,1) | |
| INSERT INTO #t VALUES (1,36,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (1,36,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (1,36,3761,59,2,5.6) | |
| INSERT INTO #t VALUES (2,0,3761,17,2,14.8533) | |
| INSERT INTO #t VALUES (2,0,3761,18,2,7.85185) | |
| INSERT INTO #t VALUES (2,1,3761,17,2,12.52) | |
| INSERT INTO #t VALUES (2,1,3761,18,2,7.74074) | |
| INSERT INTO #t VALUES (2,2,3761,17,2,14.4) | |
| INSERT INTO #t VALUES (2,2,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (2,3,3761,17,2,14.6) | |
| INSERT INTO #t VALUES (2,3,3761,18,2,7.62963) | |
| INSERT INTO #t VALUES (2,4,3761,17,2,11.4) | |
| INSERT INTO #t VALUES (2,4,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (2,5,3761,16,2,0.597944) | |
| INSERT INTO #t VALUES (2,5,3761,17,2,16.2437) | |
| INSERT INTO #t VALUES (2,5,3761,18,2,7.88889) | |
| INSERT INTO #t VALUES (2,5,3761,59,2,3.40665) | |
| INSERT INTO #t VALUES (2,6,3761,16,2,0.611076) | |
| INSERT INTO #t VALUES (2,6,3761,17,2,12.1333) | |
| INSERT INTO #t VALUES (2,6,3761,18,2,7.18519) | |
| INSERT INTO #t VALUES (2,6,3761,59,2,2.49772) | |
| INSERT INTO #t VALUES (2,7,3761,16,2,0.525928) | |
| INSERT INTO #t VALUES (2,7,3761,17,2,12.5071) | |
| INSERT INTO #t VALUES (2,7,3761,18,2,6.92593) | |
| INSERT INTO #t VALUES (2,7,3761,59,2,4.02506) | |
| INSERT INTO #t VALUES (2,8,3761,16,2,0.635113) | |
| INSERT INTO #t VALUES (2,8,3761,17,2,13.7038) | |
| INSERT INTO #t VALUES (2,8,3761,18,2,8.66667) | |
| INSERT INTO #t VALUES (2,8,3761,59,2,2.60611) | |
| INSERT INTO #t VALUES (2,9,3761,16,2,0.422957) | |
| INSERT INTO #t VALUES (2,9,3761,17,2,14.5333) | |
| INSERT INTO #t VALUES (2,9,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (2,9,3761,59,2,4.33585) | |
| INSERT INTO #t VALUES (2,10,3761,16,2,0.918756) | |
| INSERT INTO #t VALUES (2,10,3761,17,2,9.84524) | |
| INSERT INTO #t VALUES (2,10,3761,18,2,7.28571) | |
| INSERT INTO #t VALUES (2,10,3761,59,2,3.03193) | |
| INSERT INTO #t VALUES (2,11,3761,16,2,0.410077) | |
| INSERT INTO #t VALUES (2,11,3761,17,2,11.3333) | |
| INSERT INTO #t VALUES (2,11,3761,18,2,6.80952) | |
| INSERT INTO #t VALUES (2,11,3761,59,2,2.34676) | |
| INSERT INTO #t VALUES (2,12,3761,16,2,0.509215) | |
| INSERT INTO #t VALUES (2,12,3761,17,2,10.5104) | |
| INSERT INTO #t VALUES (2,12,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (2,12,3761,59,2,3.68746) | |
| INSERT INTO #t VALUES (2,13,3761,16,2,0.668289) | |
| INSERT INTO #t VALUES (2,13,3761,17,2,9.72917) | |
| INSERT INTO #t VALUES (2,13,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (2,13,3761,59,2,1.50808) | |
| INSERT INTO #t VALUES (2,14,3761,16,2,0.811273) | |
| INSERT INTO #t VALUES (2,14,3761,17,2,11.1556) | |
| INSERT INTO #t VALUES (2,14,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (2,14,3761,59,2,3.39521) | |
| INSERT INTO #t VALUES (2,15,3761,16,2,0.753936) | |
| INSERT INTO #t VALUES (2,15,3761,17,2,15.5556) | |
| INSERT INTO #t VALUES (2,15,3761,18,2,8.44444) | |
| INSERT INTO #t VALUES (2,15,3761,59,2,0.621947) | |
| INSERT INTO #t VALUES (2,16,3761,16,2,0.80682) | |
| INSERT INTO #t VALUES (2,16,3761,17,2,11.5185) | |
| INSERT INTO #t VALUES (2,16,3761,18,2,6.94444) | |
| INSERT INTO #t VALUES (2,16,3761,59,2,-0.50561) | |
| INSERT INTO #t VALUES (2,17,3761,16,2,1) | |
| INSERT INTO #t VALUES (2,17,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (2,17,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (2,17,3761,59,2,-1.64562) | |
| INSERT INTO #t VALUES (2,18,3761,16,2,0.571429) | |
| INSERT INTO #t VALUES (2,18,3761,17,2,22) | |
| INSERT INTO #t VALUES (2,18,3761,18,2,5.5) | |
| INSERT INTO #t VALUES (2,18,3761,59,2,2.8) | |
| INSERT INTO #t VALUES (2,19,3761,16,2,1) | |
| INSERT INTO #t VALUES (2,19,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (2,19,3761,18,2,8) | |
| INSERT INTO #t VALUES (2,19,3761,59,2,3.8) | |
| INSERT INTO #t VALUES (2,20,3761,16,2,1) | |
| INSERT INTO #t VALUES (2,20,3761,17,2,9.25) | |
| INSERT INTO #t VALUES (2,20,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (2,20,3761,59,2,3.6) | |
| INSERT INTO #t VALUES (2,21,3761,16,2,0.428571) | |
| INSERT INTO #t VALUES (2,21,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (2,21,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (2,21,3761,59,2,-0.6) | |
| INSERT INTO #t VALUES (2,22,3761,16,2,1) | |
| INSERT INTO #t VALUES (2,22,3761,17,2,11) | |
| INSERT INTO #t VALUES (2,22,3761,18,2,8.25) | |
| INSERT INTO #t VALUES (2,22,3761,59,2,3.8) | |
| INSERT INTO #t VALUES (2,23,3761,16,2,0) | |
| INSERT INTO #t VALUES (2,23,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (2,23,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (2,23,3761,59,2,4.4) | |
| INSERT INTO #t VALUES (2,24,3761,16,2,0.428571) | |
| INSERT INTO #t VALUES (2,24,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (2,24,3761,18,2,8) | |
| INSERT INTO #t VALUES (2,24,3761,59,2,1.8) | |
| INSERT INTO #t VALUES (2,25,3761,16,2,0) | |
| INSERT INTO #t VALUES (2,25,3761,17,2,25) | |
| INSERT INTO #t VALUES (2,25,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (2,25,3761,59,2,4.4) | |
| INSERT INTO #t VALUES (2,26,3761,16,2,0) | |
| INSERT INTO #t VALUES (2,26,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (2,26,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (2,26,3761,59,2,3.8) | |
| INSERT INTO #t VALUES (2,27,3761,16,2,0.571429) | |
| INSERT INTO #t VALUES (2,27,3761,17,2,22.5) | |
| INSERT INTO #t VALUES (2,27,3761,18,2,11.25) | |
| INSERT INTO #t VALUES (2,27,3761,59,2,2) | |
| INSERT INTO #t VALUES (2,28,3761,16,2,0.571429) | |
| INSERT INTO #t VALUES (2,28,3761,17,2,12) | |
| INSERT INTO #t VALUES (2,28,3761,18,2,6) | |
| INSERT INTO #t VALUES (2,28,3761,59,2,0.6) | |
| INSERT INTO #t VALUES (2,29,3761,16,2,0.428571) | |
| INSERT INTO #t VALUES (2,29,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (2,29,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (2,29,3761,59,2,3) | |
| INSERT INTO #t VALUES (2,30,3761,16,2,0.571429) | |
| INSERT INTO #t VALUES (2,30,3761,17,2,11.5) | |
| INSERT INTO #t VALUES (2,30,3761,18,2,5.75) | |
| INSERT INTO #t VALUES (2,30,3761,59,2,1.2) | |
| INSERT INTO #t VALUES (2,31,3761,16,2,1) | |
| INSERT INTO #t VALUES (2,31,3761,17,2,8.66667) | |
| INSERT INTO #t VALUES (2,31,3761,18,2,6.5) | |
| INSERT INTO #t VALUES (2,31,3761,59,2,4.4) | |
| INSERT INTO #t VALUES (2,32,3761,16,2,1) | |
| INSERT INTO #t VALUES (2,32,3761,17,2,10.5) | |
| INSERT INTO #t VALUES (2,32,3761,18,2,10.5) | |
| INSERT INTO #t VALUES (2,32,3761,59,2,3.6) | |
| INSERT INTO #t VALUES (2,33,3761,16,2,0.571429) | |
| INSERT INTO #t VALUES (2,33,3761,17,2,43) | |
| INSERT INTO #t VALUES (2,33,3761,18,2,10.75) | |
| INSERT INTO #t VALUES (2,33,3761,59,2,1.4) | |
| INSERT INTO #t VALUES (2,34,3761,16,2,0) | |
| INSERT INTO #t VALUES (2,34,3761,17,2,17.5) | |
| INSERT INTO #t VALUES (2,34,3761,18,2,8.75) | |
| INSERT INTO #t VALUES (2,34,3761,59,2,2.2) | |
| INSERT INTO #t VALUES (2,35,3761,16,2,0.428571) | |
| INSERT INTO #t VALUES (2,35,3761,17,2,34) | |
| INSERT INTO #t VALUES (2,35,3761,18,2,8.5) | |
| INSERT INTO #t VALUES (2,35,3761,59,2,3.2) | |
| INSERT INTO #t VALUES (2,36,3761,16,2,1) | |
| INSERT INTO #t VALUES (2,36,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (2,36,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (2,36,3761,59,2,1.6) | |
| INSERT INTO #t VALUES (3,0,3761,17,2,14.8533) | |
| INSERT INTO #t VALUES (3,0,3761,18,2,7.85185) | |
| INSERT INTO #t VALUES (3,1,3761,17,2,12.52) | |
| INSERT INTO #t VALUES (3,1,3761,18,2,7.74074) | |
| INSERT INTO #t VALUES (3,2,3761,17,2,14.4) | |
| INSERT INTO #t VALUES (3,2,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (3,3,3761,17,2,14.6) | |
| INSERT INTO #t VALUES (3,3,3761,18,2,7.62963) | |
| INSERT INTO #t VALUES (3,4,3761,17,2,11.4) | |
| INSERT INTO #t VALUES (3,4,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (3,5,3761,16,2,0.646813) | |
| INSERT INTO #t VALUES (3,5,3761,17,2,16.2437) | |
| INSERT INTO #t VALUES (3,5,3761,18,2,7.88889) | |
| INSERT INTO #t VALUES (3,5,3761,59,2,3.64898) | |
| INSERT INTO #t VALUES (3,6,3761,16,2,0.575978) | |
| INSERT INTO #t VALUES (3,6,3761,17,2,12.1333) | |
| INSERT INTO #t VALUES (3,6,3761,18,2,7.18519) | |
| INSERT INTO #t VALUES (3,6,3761,59,2,2.23407) | |
| INSERT INTO #t VALUES (3,7,3761,16,2,0.569259) | |
| INSERT INTO #t VALUES (3,7,3761,17,2,12.5071) | |
| INSERT INTO #t VALUES (3,7,3761,18,2,6.92593) | |
| INSERT INTO #t VALUES (3,7,3761,59,2,3.60508) | |
| INSERT INTO #t VALUES (3,8,3761,16,2,0.592681) | |
| INSERT INTO #t VALUES (3,8,3761,17,2,13.7038) | |
| INSERT INTO #t VALUES (3,8,3761,18,2,8.66667) | |
| INSERT INTO #t VALUES (3,8,3761,59,2,3.56413) | |
| INSERT INTO #t VALUES (3,9,3761,16,2,0.51467) | |
| INSERT INTO #t VALUES (3,9,3761,17,2,14.5333) | |
| INSERT INTO #t VALUES (3,9,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (3,9,3761,59,2,3.57838) | |
| INSERT INTO #t VALUES (3,10,3761,16,2,0.773707) | |
| INSERT INTO #t VALUES (3,10,3761,17,2,9.84524) | |
| INSERT INTO #t VALUES (3,10,3761,18,2,7.28571) | |
| INSERT INTO #t VALUES (3,10,3761,59,2,2.41177) | |
| INSERT INTO #t VALUES (3,11,3761,16,2,0.469203) | |
| INSERT INTO #t VALUES (3,11,3761,17,2,11.3333) | |
| INSERT INTO #t VALUES (3,11,3761,18,2,6.80952) | |
| INSERT INTO #t VALUES (3,11,3761,59,2,2.09652) | |
| INSERT INTO #t VALUES (3,12,3761,16,2,0.460099) | |
| INSERT INTO #t VALUES (3,12,3761,17,2,10.5104) | |
| INSERT INTO #t VALUES (3,12,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (3,12,3761,59,2,2.58381) | |
| INSERT INTO #t VALUES (3,13,3761,16,2,0.604355) | |
| INSERT INTO #t VALUES (3,13,3761,17,2,9.72917) | |
| INSERT INTO #t VALUES (3,13,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (3,13,3761,59,2,2.08705) | |
| INSERT INTO #t VALUES (3,14,3761,16,2,0.729344) | |
| INSERT INTO #t VALUES (3,14,3761,17,2,11.1556) | |
| INSERT INTO #t VALUES (3,14,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (3,14,3761,59,2,3.036) | |
| INSERT INTO #t VALUES (3,15,3761,16,2,0.669379) | |
| INSERT INTO #t VALUES (3,15,3761,17,2,15.5556) | |
| INSERT INTO #t VALUES (3,15,3761,18,2,8.44444) | |
| INSERT INTO #t VALUES (3,15,3761,59,2,0.767657) | |
| INSERT INTO #t VALUES (3,16,3761,16,2,0.764107) | |
| INSERT INTO #t VALUES (3,16,3761,17,2,11.5185) | |
| INSERT INTO #t VALUES (3,16,3761,18,2,6.94444) | |
| INSERT INTO #t VALUES (3,16,3761,59,2,1.40958) | |
| INSERT INTO #t VALUES (3,17,3761,16,2,0) | |
| INSERT INTO #t VALUES (3,17,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (3,17,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (3,17,3761,59,2,-1.20367) | |
| INSERT INTO #t VALUES (3,18,3761,16,2,0.285714) | |
| INSERT INTO #t VALUES (3,18,3761,17,2,22) | |
| INSERT INTO #t VALUES (3,18,3761,18,2,5.5) | |
| INSERT INTO #t VALUES (3,18,3761,59,2,1.6) | |
| INSERT INTO #t VALUES (3,19,3761,16,2,1) | |
| INSERT INTO #t VALUES (3,19,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (3,19,3761,18,2,8) | |
| INSERT INTO #t VALUES (3,19,3761,59,2,4.6) | |
| INSERT INTO #t VALUES (3,20,3761,16,2,1) | |
| INSERT INTO #t VALUES (3,20,3761,17,2,9.25) | |
| INSERT INTO #t VALUES (3,20,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (3,20,3761,59,2,5.2) | |
| INSERT INTO #t VALUES (3,21,3761,16,2,0.714286) | |
| INSERT INTO #t VALUES (3,21,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (3,21,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (3,21,3761,59,2,0.8) | |
| INSERT INTO #t VALUES (3,22,3761,16,2,1) | |
| INSERT INTO #t VALUES (3,22,3761,17,2,11) | |
| INSERT INTO #t VALUES (3,22,3761,18,2,8.25) | |
| INSERT INTO #t VALUES (3,22,3761,59,2,5.6) | |
| INSERT INTO #t VALUES (3,23,3761,16,2,0) | |
| INSERT INTO #t VALUES (3,23,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (3,23,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (3,23,3761,59,2,4.8) | |
| INSERT INTO #t VALUES (3,24,3761,16,2,0.714286) | |
| INSERT INTO #t VALUES (3,24,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (3,24,3761,18,2,8) | |
| INSERT INTO #t VALUES (3,24,3761,59,2,3.6) | |
| INSERT INTO #t VALUES (3,25,3761,16,2,0) | |
| INSERT INTO #t VALUES (3,25,3761,17,2,25) | |
| INSERT INTO #t VALUES (3,25,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (3,25,3761,59,2,5.8) | |
| INSERT INTO #t VALUES (3,26,3761,16,2,0) | |
| INSERT INTO #t VALUES (3,26,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (3,26,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (3,26,3761,59,2,6.6) | |
| INSERT INTO #t VALUES (3,27,3761,16,2,0.285714) | |
| INSERT INTO #t VALUES (3,27,3761,17,2,22.5) | |
| INSERT INTO #t VALUES (3,27,3761,18,2,11.25) | |
| INSERT INTO #t VALUES (3,27,3761,59,2,1) | |
| INSERT INTO #t VALUES (3,28,3761,16,2,0.285714) | |
| INSERT INTO #t VALUES (3,28,3761,17,2,12) | |
| INSERT INTO #t VALUES (3,28,3761,18,2,6) | |
| INSERT INTO #t VALUES (3,28,3761,59,2,0.2) | |
| INSERT INTO #t VALUES (3,29,3761,16,2,0.714286) | |
| INSERT INTO #t VALUES (3,29,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (3,29,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (3,29,3761,59,2,6) | |
| INSERT INTO #t VALUES (3,30,3761,16,2,0.285714) | |
| INSERT INTO #t VALUES (3,30,3761,17,2,11.5) | |
| INSERT INTO #t VALUES (3,30,3761,18,2,5.75) | |
| INSERT INTO #t VALUES (3,30,3761,59,2,2.4) | |
| INSERT INTO #t VALUES (3,31,3761,16,2,1) | |
| INSERT INTO #t VALUES (3,31,3761,17,2,8.66667) | |
| INSERT INTO #t VALUES (3,31,3761,18,2,6.5) | |
| INSERT INTO #t VALUES (3,31,3761,59,2,2.8) | |
| INSERT INTO #t VALUES (3,32,3761,16,2,1) | |
| INSERT INTO #t VALUES (3,32,3761,17,2,10.5) | |
| INSERT INTO #t VALUES (3,32,3761,18,2,10.5) | |
| INSERT INTO #t VALUES (3,32,3761,59,2,4.2) | |
| INSERT INTO #t VALUES (3,33,3761,16,2,0.285714) | |
| INSERT INTO #t VALUES (3,33,3761,17,2,43) | |
| INSERT INTO #t VALUES (3,33,3761,18,2,10.75) | |
| INSERT INTO #t VALUES (3,33,3761,59,2,2.8) | |
| INSERT INTO #t VALUES (3,34,3761,16,2,0) | |
| INSERT INTO #t VALUES (3,34,3761,17,2,17.5) | |
| INSERT INTO #t VALUES (3,34,3761,18,2,8.75) | |
| INSERT INTO #t VALUES (3,34,3761,59,2,3.4) | |
| INSERT INTO #t VALUES (3,35,3761,16,2,0.714286) | |
| INSERT INTO #t VALUES (3,35,3761,17,2,34) | |
| INSERT INTO #t VALUES (3,35,3761,18,2,8.5) | |
| INSERT INTO #t VALUES (3,35,3761,59,2,3.4) | |
| INSERT INTO #t VALUES (3,36,3761,16,2,1) | |
| INSERT INTO #t VALUES (3,36,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (3,36,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (3,36,3761,59,2,0.2) | |
| INSERT INTO #t VALUES (4,0,3761,17,2,14.8533) | |
| INSERT INTO #t VALUES (4,0,3761,18,2,7.85185) | |
| INSERT INTO #t VALUES (4,1,3761,17,2,12.52) | |
| INSERT INTO #t VALUES (4,1,3761,18,2,7.74074) | |
| INSERT INTO #t VALUES (4,2,3761,17,2,14.4) | |
| INSERT INTO #t VALUES (4,2,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (4,3,3761,17,2,14.6) | |
| INSERT INTO #t VALUES (4,3,3761,18,2,7.62963) | |
| INSERT INTO #t VALUES (4,4,3761,17,2,11.4) | |
| INSERT INTO #t VALUES (4,4,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (4,5,3761,16,2,0.570882) | |
| INSERT INTO #t VALUES (4,5,3761,17,2,16.2437) | |
| INSERT INTO #t VALUES (4,5,3761,18,2,7.88889) | |
| INSERT INTO #t VALUES (4,5,3761,59,2,3.47058) | |
| INSERT INTO #t VALUES (4,6,3761,16,2,0.7357) | |
| INSERT INTO #t VALUES (4,6,3761,17,2,12.1333) | |
| INSERT INTO #t VALUES (4,6,3761,18,2,7.18519) | |
| INSERT INTO #t VALUES (4,6,3761,59,2,1.27939) | |
| INSERT INTO #t VALUES (4,7,3761,16,2,0.511281) | |
| INSERT INTO #t VALUES (4,7,3761,17,2,12.5071) | |
| INSERT INTO #t VALUES (4,7,3761,18,2,6.92593) | |
| INSERT INTO #t VALUES (4,7,3761,59,2,3.60668) | |
| INSERT INTO #t VALUES (4,8,3761,16,2,0.783732) | |
| INSERT INTO #t VALUES (4,8,3761,17,2,13.7038) | |
| INSERT INTO #t VALUES (4,8,3761,18,2,8.66667) | |
| INSERT INTO #t VALUES (4,8,3761,59,2,1.79459) | |
| INSERT INTO #t VALUES (4,9,3761,16,2,0.305743) | |
| INSERT INTO #t VALUES (4,9,3761,17,2,14.5333) | |
| INSERT INTO #t VALUES (4,9,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (4,9,3761,59,2,2.79393) | |
| INSERT INTO #t VALUES (4,10,3761,16,2,1.144) | |
| INSERT INTO #t VALUES (4,10,3761,17,2,9.84524) | |
| INSERT INTO #t VALUES (4,10,3761,18,2,7.28571) | |
| INSERT INTO #t VALUES (4,10,3761,59,2,2.64008) | |
| INSERT INTO #t VALUES (4,11,3761,16,2,0.335768) | |
| INSERT INTO #t VALUES (4,11,3761,17,2,11.3333) | |
| INSERT INTO #t VALUES (4,11,3761,18,2,6.80952) | |
| INSERT INTO #t VALUES (4,11,3761,59,2,2.62512) | |
| INSERT INTO #t VALUES (4,12,3761,16,2,0.680611) | |
| INSERT INTO #t VALUES (4,12,3761,17,2,10.5104) | |
| INSERT INTO #t VALUES (4,12,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (4,12,3761,59,2,2.79898) | |
| INSERT INTO #t VALUES (4,13,3761,16,2,0.825974) | |
| INSERT INTO #t VALUES (4,13,3761,17,2,9.72917) | |
| INSERT INTO #t VALUES (4,13,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (4,13,3761,59,2,1.88859) | |
| INSERT INTO #t VALUES (4,14,3761,16,2,1.01442) | |
| INSERT INTO #t VALUES (4,14,3761,17,2,11.1556) | |
| INSERT INTO #t VALUES (4,14,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (4,14,3761,59,2,1.63599) | |
| INSERT INTO #t VALUES (4,15,3761,16,2,0.830319) | |
| INSERT INTO #t VALUES (4,15,3761,17,2,15.5556) | |
| INSERT INTO #t VALUES (4,15,3761,18,2,8.44444) | |
| INSERT INTO #t VALUES (4,15,3761,59,2,2.66759) | |
| INSERT INTO #t VALUES (4,16,3761,16,2,0.881331) | |
| INSERT INTO #t VALUES (4,16,3761,17,2,11.5185) | |
| INSERT INTO #t VALUES (4,16,3761,18,2,6.94444) | |
| INSERT INTO #t VALUES (4,16,3761,59,2,1.47678) | |
| INSERT INTO #t VALUES (4,17,3761,16,2,-1.46667) | |
| INSERT INTO #t VALUES (4,17,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (4,17,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (4,17,3761,59,2,2.93941) | |
| INSERT INTO #t VALUES (4,18,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,18,3761,17,2,22) | |
| INSERT INTO #t VALUES (4,18,3761,18,2,5.5) | |
| INSERT INTO #t VALUES (4,18,3761,59,2,3.9) | |
| INSERT INTO #t VALUES (4,19,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,19,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (4,19,3761,18,2,8) | |
| INSERT INTO #t VALUES (4,19,3761,59,2,2.9) | |
| INSERT INTO #t VALUES (4,20,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,20,3761,17,2,9.25) | |
| INSERT INTO #t VALUES (4,20,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (4,20,3761,59,2,2.3) | |
| INSERT INTO #t VALUES (4,21,3761,16,2,9.99201e-016) | |
| INSERT INTO #t VALUES (4,21,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (4,21,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (4,21,3761,59,2,4.2) | |
| INSERT INTO #t VALUES (4,22,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,22,3761,17,2,11) | |
| INSERT INTO #t VALUES (4,22,3761,18,2,8.25) | |
| INSERT INTO #t VALUES (4,22,3761,59,2,3.9) | |
| INSERT INTO #t VALUES (4,23,3761,16,2,0) | |
| INSERT INTO #t VALUES (4,23,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (4,23,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (4,23,3761,59,2,4.2) | |
| INSERT INTO #t VALUES (4,24,3761,16,2,9.99201e-016) | |
| INSERT INTO #t VALUES (4,24,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (4,24,3761,18,2,8) | |
| INSERT INTO #t VALUES (4,24,3761,59,2,1.4) | |
| INSERT INTO #t VALUES (4,25,3761,16,2,0) | |
| INSERT INTO #t VALUES (4,25,3761,17,2,25) | |
| INSERT INTO #t VALUES (4,25,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (4,25,3761,59,2,0.7) | |
| INSERT INTO #t VALUES (4,26,3761,16,2,0) | |
| INSERT INTO #t VALUES (4,26,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (4,26,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (4,26,3761,59,2,0.4) | |
| INSERT INTO #t VALUES (4,27,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,27,3761,17,2,22.5) | |
| INSERT INTO #t VALUES (4,27,3761,18,2,11.25) | |
| INSERT INTO #t VALUES (4,27,3761,59,2,1) | |
| INSERT INTO #t VALUES (4,28,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,28,3761,17,2,12) | |
| INSERT INTO #t VALUES (4,28,3761,18,2,6) | |
| INSERT INTO #t VALUES (4,28,3761,59,2,5.8) | |
| INSERT INTO #t VALUES (4,29,3761,16,2,9.99201e-016) | |
| INSERT INTO #t VALUES (4,29,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (4,29,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (4,29,3761,59,2,2) | |
| INSERT INTO #t VALUES (4,30,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,30,3761,17,2,11.5) | |
| INSERT INTO #t VALUES (4,30,3761,18,2,5.75) | |
| INSERT INTO #t VALUES (4,30,3761,59,2,4.1) | |
| INSERT INTO #t VALUES (4,31,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,31,3761,17,2,8.66667) | |
| INSERT INTO #t VALUES (4,31,3761,18,2,6.5) | |
| INSERT INTO #t VALUES (4,31,3761,59,2,1.7) | |
| INSERT INTO #t VALUES (4,32,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,32,3761,17,2,10.5) | |
| INSERT INTO #t VALUES (4,32,3761,18,2,10.5) | |
| INSERT INTO #t VALUES (4,32,3761,59,2,-0.2) | |
| INSERT INTO #t VALUES (4,33,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,33,3761,17,2,43) | |
| INSERT INTO #t VALUES (4,33,3761,18,2,10.75) | |
| INSERT INTO #t VALUES (4,33,3761,59,2,2.2) | |
| INSERT INTO #t VALUES (4,34,3761,16,2,0) | |
| INSERT INTO #t VALUES (4,34,3761,17,2,17.5) | |
| INSERT INTO #t VALUES (4,34,3761,18,2,8.75) | |
| INSERT INTO #t VALUES (4,34,3761,59,2,4.6) | |
| INSERT INTO #t VALUES (4,35,3761,16,2,9.99201e-016) | |
| INSERT INTO #t VALUES (4,35,3761,17,2,34) | |
| INSERT INTO #t VALUES (4,35,3761,18,2,8.5) | |
| INSERT INTO #t VALUES (4,35,3761,59,2,1.6) | |
| INSERT INTO #t VALUES (4,36,3761,16,2,1) | |
| INSERT INTO #t VALUES (4,36,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (4,36,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (4,36,3761,59,2,4.8) | |
| INSERT INTO #t VALUES (5,0,3761,17,2,14.8533) | |
| INSERT INTO #t VALUES (5,0,3761,18,2,7.85185) | |
| INSERT INTO #t VALUES (5,1,3761,17,2,12.52) | |
| INSERT INTO #t VALUES (5,1,3761,18,2,7.74074) | |
| INSERT INTO #t VALUES (5,2,3761,17,2,14.4) | |
| INSERT INTO #t VALUES (5,2,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (5,3,3761,17,2,14.6) | |
| INSERT INTO #t VALUES (5,3,3761,18,2,7.62963) | |
| INSERT INTO #t VALUES (5,4,3761,17,2,11.4) | |
| INSERT INTO #t VALUES (5,4,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (5,5,3761,16,2,0.901432) | |
| INSERT INTO #t VALUES (5,5,3761,17,2,16.2437) | |
| INSERT INTO #t VALUES (5,5,3761,18,2,7.88889) | |
| INSERT INTO #t VALUES (5,5,3761,59,2,3.22772) | |
| INSERT INTO #t VALUES (5,6,3761,16,2,0.296336) | |
| INSERT INTO #t VALUES (5,6,3761,17,2,12.1333) | |
| INSERT INTO #t VALUES (5,6,3761,18,2,7.18519) | |
| INSERT INTO #t VALUES (5,6,3761,59,2,2.00372) | |
| INSERT INTO #t VALUES (5,7,3761,16,2,0.628327) | |
| INSERT INTO #t VALUES (5,7,3761,17,2,12.5071) | |
| INSERT INTO #t VALUES (5,7,3761,18,2,6.92593) | |
| INSERT INTO #t VALUES (5,7,3761,59,2,3.85199) | |
| INSERT INTO #t VALUES (5,8,3761,16,2,0.612226) | |
| INSERT INTO #t VALUES (5,8,3761,17,2,13.7038) | |
| INSERT INTO #t VALUES (5,8,3761,18,2,8.66667) | |
| INSERT INTO #t VALUES (5,8,3761,59,2,1.7856) | |
| INSERT INTO #t VALUES (5,9,3761,16,2,0.522174) | |
| INSERT INTO #t VALUES (5,9,3761,17,2,14.5333) | |
| INSERT INTO #t VALUES (5,9,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (5,9,3761,59,2,4.01157) | |
| INSERT INTO #t VALUES (5,10,3761,16,2,0.628588) | |
| INSERT INTO #t VALUES (5,10,3761,17,2,9.84524) | |
| INSERT INTO #t VALUES (5,10,3761,18,2,7.28571) | |
| INSERT INTO #t VALUES (5,10,3761,59,2,3.27799) | |
| INSERT INTO #t VALUES (5,11,3761,16,2,0.704489) | |
| INSERT INTO #t VALUES (5,11,3761,17,2,11.3333) | |
| INSERT INTO #t VALUES (5,11,3761,18,2,6.80952) | |
| INSERT INTO #t VALUES (5,11,3761,59,2,2.52811) | |
| INSERT INTO #t VALUES (5,12,3761,16,2,0.689898) | |
| INSERT INTO #t VALUES (5,12,3761,17,2,10.5104) | |
| INSERT INTO #t VALUES (5,12,3761,18,2,8.09524) | |
| INSERT INTO #t VALUES (5,12,3761,59,2,3.7683) | |
| INSERT INTO #t VALUES (5,13,3761,16,2,0.241274) | |
| INSERT INTO #t VALUES (5,13,3761,17,2,9.72917) | |
| INSERT INTO #t VALUES (5,13,3761,18,2,7.33333) | |
| INSERT INTO #t VALUES (5,13,3761,59,2,2.30653) | |
| INSERT INTO #t VALUES (5,14,3761,16,2,0.128695) | |
| INSERT INTO #t VALUES (5,14,3761,17,2,11.1556) | |
| INSERT INTO #t VALUES (5,14,3761,18,2,7.44444) | |
| INSERT INTO #t VALUES (5,14,3761,59,2,3.04148) | |
| INSERT INTO #t VALUES (5,15,3761,16,2,0.513982) | |
| INSERT INTO #t VALUES (5,15,3761,17,2,15.5556) | |
| INSERT INTO #t VALUES (5,15,3761,18,2,8.44444) | |
| INSERT INTO #t VALUES (5,15,3761,59,2,1.47638) | |
| INSERT INTO #t VALUES (5,16,3761,16,2,0.723307) | |
| INSERT INTO #t VALUES (5,16,3761,17,2,11.5185) | |
| INSERT INTO #t VALUES (5,16,3761,18,2,6.94444) | |
| INSERT INTO #t VALUES (5,16,3761,59,2,-0.361788) | |
| INSERT INTO #t VALUES (5,17,3761,16,2,-3.8) | |
| INSERT INTO #t VALUES (5,17,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (5,17,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (5,17,3761,59,2,0.4389) | |
| INSERT INTO #t VALUES (5,18,3761,16,2,-0.285714) | |
| INSERT INTO #t VALUES (5,18,3761,17,2,22) | |
| INSERT INTO #t VALUES (5,18,3761,18,2,5.5) | |
| INSERT INTO #t VALUES (5,18,3761,59,2,3.2) | |
| INSERT INTO #t VALUES (5,19,3761,16,2,1) | |
| INSERT INTO #t VALUES (5,19,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (5,19,3761,18,2,8) | |
| INSERT INTO #t VALUES (5,19,3761,59,2,3.2) | |
| INSERT INTO #t VALUES (5,20,3761,16,2,1) | |
| INSERT INTO #t VALUES (5,20,3761,17,2,9.25) | |
| INSERT INTO #t VALUES (5,20,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (5,20,3761,59,2,3.4) | |
| INSERT INTO #t VALUES (5,21,3761,16,2,1.28571) | |
| INSERT INTO #t VALUES (5,21,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (5,21,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (5,21,3761,59,2,0.6) | |
| INSERT INTO #t VALUES (5,22,3761,16,2,0) | |
| INSERT INTO #t VALUES (5,22,3761,17,2,11) | |
| INSERT INTO #t VALUES (5,22,3761,18,2,8.25) | |
| INSERT INTO #t VALUES (5,22,3761,59,2,3.2) | |
| INSERT INTO #t VALUES (5,23,3761,16,2,1) | |
| INSERT INTO #t VALUES (5,23,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (5,23,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (5,23,3761,59,2,4.6) | |
| INSERT INTO #t VALUES (5,24,3761,16,2,1.28571) | |
| INSERT INTO #t VALUES (5,24,3761,17,2,10.6667) | |
| INSERT INTO #t VALUES (5,24,3761,18,2,8) | |
| INSERT INTO #t VALUES (5,24,3761,59,2,0.2) | |
| INSERT INTO #t VALUES (5,25,3761,16,2,1) | |
| INSERT INTO #t VALUES (5,25,3761,17,2,25) | |
| INSERT INTO #t VALUES (5,25,3761,18,2,6.25) | |
| INSERT INTO #t VALUES (5,25,3761,59,2,2.6) | |
| INSERT INTO #t VALUES (5,26,3761,16,2,1) | |
| INSERT INTO #t VALUES (5,26,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (5,26,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (5,26,3761,59,2,1.2) | |
| INSERT INTO #t VALUES (5,27,3761,16,2,0.714286) | |
| INSERT INTO #t VALUES (5,27,3761,17,2,22.5) | |
| INSERT INTO #t VALUES (5,27,3761,18,2,11.25) | |
| INSERT INTO #t VALUES (5,27,3761,59,2,2) | |
| INSERT INTO #t VALUES (5,28,3761,16,2,-0.285714) | |
| INSERT INTO #t VALUES (5,28,3761,17,2,12) | |
| INSERT INTO #t VALUES (5,28,3761,18,2,6) | |
| INSERT INTO #t VALUES (5,28,3761,59,2,3.4) | |
| INSERT INTO #t VALUES (5,29,3761,16,2,1.28571) | |
| INSERT INTO #t VALUES (5,29,3761,17,2,18.5) | |
| INSERT INTO #t VALUES (5,29,3761,18,2,9.25) | |
| INSERT INTO #t VALUES (5,29,3761,59,2,2) | |
| INSERT INTO #t VALUES (5,30,3761,16,2,-0.285714) | |
| INSERT INTO #t VALUES (5,30,3761,17,2,11.5) | |
| INSERT INTO #t VALUES (5,30,3761,18,2,5.75) | |
| INSERT INTO #t VALUES (5,30,3761,59,2,1.8) | |
| INSERT INTO #t VALUES (5,31,3761,16,2,0) | |
| INSERT INTO #t VALUES (5,31,3761,17,2,8.66667) | |
| INSERT INTO #t VALUES (5,31,3761,18,2,6.5) | |
| INSERT INTO #t VALUES (5,31,3761,59,2,3.6) | |
| INSERT INTO #t VALUES (5,32,3761,16,2,1) | |
| INSERT INTO #t VALUES (5,32,3761,17,2,10.5) | |
| INSERT INTO #t VALUES (5,32,3761,18,2,10.5) | |
| INSERT INTO #t VALUES (5,32,3761,59,2,0.4) | |
| INSERT INTO #t VALUES (5,33,3761,16,2,-0.285714) | |
| INSERT INTO #t VALUES (5,33,3761,17,2,43) | |
| INSERT INTO #t VALUES (5,33,3761,18,2,10.75) | |
| INSERT INTO #t VALUES (5,33,3761,59,2,1.6) | |
| INSERT INTO #t VALUES (5,34,3761,16,2,1) | |
| INSERT INTO #t VALUES (5,34,3761,17,2,17.5) | |
| INSERT INTO #t VALUES (5,34,3761,18,2,8.75) | |
| INSERT INTO #t VALUES (5,34,3761,59,2,1.8) | |
| INSERT INTO #t VALUES (5,35,3761,16,2,0.285714) | |
| INSERT INTO #t VALUES (5,35,3761,17,2,34) | |
| INSERT INTO #t VALUES (5,35,3761,18,2,8.5) | |
| INSERT INTO #t VALUES (5,35,3761,59,2,3.8) | |
| INSERT INTO #t VALUES (5,36,3761,16,2,1) | |
| INSERT INTO #t VALUES (5,36,3761,17,2,10.3333) | |
| INSERT INTO #t VALUES (5,36,3761,18,2,7.75) | |
| INSERT INTO #t VALUES (5,36,3761,59,2,2.4) | |
| INSERT INTO #t VALUES (1,0,3761,17,3,13.1667) | |
| INSERT INTO #t VALUES (1,0,3761,59,3,2.94444) | |
| INSERT INTO #t VALUES (1,1,3761,17,3,15.625) | |
| INSERT INTO #t VALUES (1,1,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (1,2,3761,17,3,12.5833) | |
| INSERT INTO #t VALUES (1,2,3761,59,3,2) | |
| INSERT INTO #t VALUES (1,3,3761,17,3,11.5417) | |
| INSERT INTO #t VALUES (1,3,3761,59,3,1.94444) | |
| INSERT INTO #t VALUES (1,4,3761,17,3,11.65) | |
| INSERT INTO #t VALUES (1,4,3761,59,3,2.55556) | |
| INSERT INTO #t VALUES (1,5,3761,16,3,1) | |
| INSERT INTO #t VALUES (1,5,3761,17,3,14.25) | |
| INSERT INTO #t VALUES (1,5,3761,18,3,3.7288) | |
| INSERT INTO #t VALUES (1,5,3761,59,3,2.77778) | |
| INSERT INTO #t VALUES (1,6,3761,16,3,0.896393) | |
| INSERT INTO #t VALUES (1,6,3761,17,3,13.65) | |
| INSERT INTO #t VALUES (1,6,3761,18,3,10.404) | |
| INSERT INTO #t VALUES (1,6,3761,59,3,3.83333) | |
| INSERT INTO #t VALUES (1,7,3761,16,3,0.790268) | |
| INSERT INTO #t VALUES (1,7,3761,17,3,12.4) | |
| INSERT INTO #t VALUES (1,7,3761,18,3,12.2536) | |
| INSERT INTO #t VALUES (1,7,3761,59,3,3.88889) | |
| INSERT INTO #t VALUES (1,8,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (1,8,3761,17,3,18.125) | |
| INSERT INTO #t VALUES (1,8,3761,18,3,6.88535) | |
| INSERT INTO #t VALUES (1,8,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (1,9,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (1,9,3761,17,3,12.4167) | |
| INSERT INTO #t VALUES (1,9,3761,18,3,4.61223) | |
| INSERT INTO #t VALUES (1,9,3761,59,3,2.61111) | |
| INSERT INTO #t VALUES (1,10,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (1,10,3761,17,3,9.25) | |
| INSERT INTO #t VALUES (1,10,3761,18,3,7.90779) | |
| INSERT INTO #t VALUES (1,10,3761,59,3,3.27778) | |
| INSERT INTO #t VALUES (1,11,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (1,11,3761,17,3,9.16667) | |
| INSERT INTO #t VALUES (1,11,3761,18,3,0.751258) | |
| INSERT INTO #t VALUES (1,11,3761,59,3,4.16667) | |
| INSERT INTO #t VALUES (1,12,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (1,12,3761,17,3,15.5) | |
| INSERT INTO #t VALUES (1,12,3761,18,3,10.1983) | |
| INSERT INTO #t VALUES (1,12,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (1,13,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (1,13,3761,17,3,8.91667) | |
| INSERT INTO #t VALUES (1,13,3761,18,3,8.4886) | |
| INSERT INTO #t VALUES (1,13,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (1,14,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (1,14,3761,17,3,11.725) | |
| INSERT INTO #t VALUES (1,14,3761,18,3,1.40086) | |
| INSERT INTO #t VALUES (1,14,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (1,15,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,15,3761,17,3,9.48333) | |
| INSERT INTO #t VALUES (1,15,3761,18,3,3.75715) | |
| INSERT INTO #t VALUES (1,15,3761,59,3,2.38889) | |
| INSERT INTO #t VALUES (1,16,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,16,3761,17,3,8.41667) | |
| INSERT INTO #t VALUES (1,16,3761,18,3,5.43378) | |
| INSERT INTO #t VALUES (1,16,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (1,17,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,17,3761,17,3,10.3) | |
| INSERT INTO #t VALUES (1,17,3761,18,3,3.89976) | |
| INSERT INTO #t VALUES (1,17,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (1,18,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,18,3761,17,3,9.75) | |
| INSERT INTO #t VALUES (1,18,3761,18,3,6.11425) | |
| INSERT INTO #t VALUES (1,18,3761,59,3,2.88889) | |
| INSERT INTO #t VALUES (1,19,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,19,3761,17,3,11.35) | |
| INSERT INTO #t VALUES (1,19,3761,18,3,9.79309) | |
| INSERT INTO #t VALUES (1,19,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (1,20,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,20,3761,17,3,12.1667) | |
| INSERT INTO #t VALUES (1,20,3761,18,3,11.235) | |
| INSERT INTO #t VALUES (1,20,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (1,21,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,21,3761,17,3,8.6) | |
| INSERT INTO #t VALUES (1,21,3761,18,3,9.58081) | |
| INSERT INTO #t VALUES (1,21,3761,59,3,3.41667) | |
| INSERT INTO #t VALUES (1,22,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,22,3761,17,3,16.1111) | |
| INSERT INTO #t VALUES (1,22,3761,18,3,15.9313) | |
| INSERT INTO #t VALUES (1,22,3761,59,3,3.08333) | |
| INSERT INTO #t VALUES (1,23,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,23,3761,17,3,9.83333) | |
| INSERT INTO #t VALUES (1,23,3761,18,3,10.2432) | |
| INSERT INTO #t VALUES (1,23,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (1,24,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,24,3761,17,3,11.8333) | |
| INSERT INTO #t VALUES (1,24,3761,18,3,8.80575) | |
| INSERT INTO #t VALUES (1,24,3761,59,3,2.58333) | |
| INSERT INTO #t VALUES (1,25,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,25,3761,17,3,9.11111) | |
| INSERT INTO #t VALUES (1,25,3761,18,3,-0.365973) | |
| INSERT INTO #t VALUES (1,25,3761,59,3,2.33333) | |
| INSERT INTO #t VALUES (1,26,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,26,3761,17,3,8.77778) | |
| INSERT INTO #t VALUES (1,26,3761,18,3,1.13205) | |
| INSERT INTO #t VALUES (1,26,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (1,27,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,27,3761,17,3,21) | |
| INSERT INTO #t VALUES (1,27,3761,18,3,3.49847) | |
| INSERT INTO #t VALUES (1,27,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (1,28,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,28,3761,17,3,8.83333) | |
| INSERT INTO #t VALUES (1,28,3761,18,3,2.92043) | |
| INSERT INTO #t VALUES (1,28,3761,59,3,2.25) | |
| INSERT INTO #t VALUES (1,29,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,29,3761,17,3,8.33333) | |
| INSERT INTO #t VALUES (1,29,3761,18,3,10.0461) | |
| INSERT INTO #t VALUES (1,29,3761,59,3,2.91667) | |
| INSERT INTO #t VALUES (1,30,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,30,3761,17,3,7.8) | |
| INSERT INTO #t VALUES (1,30,3761,18,3,0.71235) | |
| INSERT INTO #t VALUES (1,30,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (1,31,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,31,3761,17,3,12.75) | |
| INSERT INTO #t VALUES (1,31,3761,18,3,9.79122) | |
| INSERT INTO #t VALUES (1,31,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (1,32,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,32,3761,17,3,9) | |
| INSERT INTO #t VALUES (1,32,3761,18,3,0.213251) | |
| INSERT INTO #t VALUES (1,32,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (1,33,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,33,3761,17,3,17.6667) | |
| INSERT INTO #t VALUES (1,33,3761,18,3,0.188711) | |
| INSERT INTO #t VALUES (1,33,3761,59,3,3.5) | |
| INSERT INTO #t VALUES (1,34,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,34,3761,17,3,48) | |
| INSERT INTO #t VALUES (1,34,3761,18,3,7.4856) | |
| INSERT INTO #t VALUES (1,34,3761,59,3,3.16667) | |
| INSERT INTO #t VALUES (1,35,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,35,3761,17,3,6.2) | |
| INSERT INTO #t VALUES (1,35,3761,18,3,4.01886) | |
| INSERT INTO #t VALUES (1,35,3761,59,3,3) | |
| INSERT INTO #t VALUES (1,36,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (1,36,3761,17,3,9.5) | |
| INSERT INTO #t VALUES (1,36,3761,18,3,14.9427) | |
| INSERT INTO #t VALUES (1,36,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (2,0,3761,17,3,13.1667) | |
| INSERT INTO #t VALUES (2,0,3761,59,3,2.94444) | |
| INSERT INTO #t VALUES (2,1,3761,17,3,15.625) | |
| INSERT INTO #t VALUES (2,1,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (2,2,3761,17,3,12.5833) | |
| INSERT INTO #t VALUES (2,2,3761,59,3,2) | |
| INSERT INTO #t VALUES (2,3,3761,17,3,11.5417) | |
| INSERT INTO #t VALUES (2,3,3761,59,3,1.94444) | |
| INSERT INTO #t VALUES (2,4,3761,17,3,11.65) | |
| INSERT INTO #t VALUES (2,4,3761,59,3,2.55556) | |
| INSERT INTO #t VALUES (2,5,3761,16,3,1) | |
| INSERT INTO #t VALUES (2,5,3761,17,3,14.25) | |
| INSERT INTO #t VALUES (2,5,3761,18,3,7.49013) | |
| INSERT INTO #t VALUES (2,5,3761,59,3,2.77778) | |
| INSERT INTO #t VALUES (2,6,3761,16,3,0.798247) | |
| INSERT INTO #t VALUES (2,6,3761,17,3,13.65) | |
| INSERT INTO #t VALUES (2,6,3761,18,3,9.01806) | |
| INSERT INTO #t VALUES (2,6,3761,59,3,3.83333) | |
| INSERT INTO #t VALUES (2,7,3761,16,3,0.615736) | |
| INSERT INTO #t VALUES (2,7,3761,17,3,12.4) | |
| INSERT INTO #t VALUES (2,7,3761,18,3,10.5915) | |
| INSERT INTO #t VALUES (2,7,3761,59,3,3.88889) | |
| INSERT INTO #t VALUES (2,8,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (2,8,3761,17,3,18.125) | |
| INSERT INTO #t VALUES (2,8,3761,18,3,7.14312) | |
| INSERT INTO #t VALUES (2,8,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (2,9,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (2,9,3761,17,3,12.4167) | |
| INSERT INTO #t VALUES (2,9,3761,18,3,3.79622) | |
| INSERT INTO #t VALUES (2,9,3761,59,3,2.61111) | |
| INSERT INTO #t VALUES (2,10,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (2,10,3761,17,3,9.25) | |
| INSERT INTO #t VALUES (2,10,3761,18,3,4.7946) | |
| INSERT INTO #t VALUES (2,10,3761,59,3,3.27778) | |
| INSERT INTO #t VALUES (2,11,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (2,11,3761,17,3,9.16667) | |
| INSERT INTO #t VALUES (2,11,3761,18,3,0.656104) | |
| INSERT INTO #t VALUES (2,11,3761,59,3,4.16667) | |
| INSERT INTO #t VALUES (2,12,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (2,12,3761,17,3,15.5) | |
| INSERT INTO #t VALUES (2,12,3761,18,3,7.21722) | |
| INSERT INTO #t VALUES (2,12,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (2,13,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (2,13,3761,17,3,8.91667) | |
| INSERT INTO #t VALUES (2,13,3761,18,3,6.03994) | |
| INSERT INTO #t VALUES (2,13,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (2,14,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (2,14,3761,17,3,11.725) | |
| INSERT INTO #t VALUES (2,14,3761,18,3,4.82332) | |
| INSERT INTO #t VALUES (2,14,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (2,15,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,15,3761,17,3,9.48333) | |
| INSERT INTO #t VALUES (2,15,3761,18,3,5.35043) | |
| INSERT INTO #t VALUES (2,15,3761,59,3,2.38889) | |
| INSERT INTO #t VALUES (2,16,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,16,3761,17,3,8.41667) | |
| INSERT INTO #t VALUES (2,16,3761,18,3,6.74902) | |
| INSERT INTO #t VALUES (2,16,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (2,17,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,17,3761,17,3,10.3) | |
| INSERT INTO #t VALUES (2,17,3761,18,3,4.13902) | |
| INSERT INTO #t VALUES (2,17,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (2,18,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,18,3761,17,3,9.75) | |
| INSERT INTO #t VALUES (2,18,3761,18,3,7.2197) | |
| INSERT INTO #t VALUES (2,18,3761,59,3,2.88889) | |
| INSERT INTO #t VALUES (2,19,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,19,3761,17,3,11.35) | |
| INSERT INTO #t VALUES (2,19,3761,18,3,7.13234) | |
| INSERT INTO #t VALUES (2,19,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (2,20,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,20,3761,17,3,12.1667) | |
| INSERT INTO #t VALUES (2,20,3761,18,3,12.2522) | |
| INSERT INTO #t VALUES (2,20,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (2,21,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,21,3761,17,3,8.6) | |
| INSERT INTO #t VALUES (2,21,3761,18,3,12.1695) | |
| INSERT INTO #t VALUES (2,21,3761,59,3,3.41667) | |
| INSERT INTO #t VALUES (2,22,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,22,3761,17,3,16.1111) | |
| INSERT INTO #t VALUES (2,22,3761,18,3,13.1186) | |
| INSERT INTO #t VALUES (2,22,3761,59,3,3.08333) | |
| INSERT INTO #t VALUES (2,23,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,23,3761,17,3,9.83333) | |
| INSERT INTO #t VALUES (2,23,3761,18,3,9.93334) | |
| INSERT INTO #t VALUES (2,23,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (2,24,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,24,3761,17,3,11.8333) | |
| INSERT INTO #t VALUES (2,24,3761,18,3,6.6747) | |
| INSERT INTO #t VALUES (2,24,3761,59,3,2.58333) | |
| INSERT INTO #t VALUES (2,25,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,25,3761,17,3,9.11111) | |
| INSERT INTO #t VALUES (2,25,3761,18,3,1.84735) | |
| INSERT INTO #t VALUES (2,25,3761,59,3,2.33333) | |
| INSERT INTO #t VALUES (2,26,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,26,3761,17,3,8.77778) | |
| INSERT INTO #t VALUES (2,26,3761,18,3,6.04509) | |
| INSERT INTO #t VALUES (2,26,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (2,27,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,27,3761,17,3,21) | |
| INSERT INTO #t VALUES (2,27,3761,18,3,4.65348) | |
| INSERT INTO #t VALUES (2,27,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (2,28,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,28,3761,17,3,8.83333) | |
| INSERT INTO #t VALUES (2,28,3761,18,3,3.45711) | |
| INSERT INTO #t VALUES (2,28,3761,59,3,2.25) | |
| INSERT INTO #t VALUES (2,29,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,29,3761,17,3,8.33333) | |
| INSERT INTO #t VALUES (2,29,3761,18,3,7.88656) | |
| INSERT INTO #t VALUES (2,29,3761,59,3,2.91667) | |
| INSERT INTO #t VALUES (2,30,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,30,3761,17,3,7.8) | |
| INSERT INTO #t VALUES (2,30,3761,18,3,0.45828) | |
| INSERT INTO #t VALUES (2,30,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (2,31,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,31,3761,17,3,12.75) | |
| INSERT INTO #t VALUES (2,31,3761,18,3,14.5524) | |
| INSERT INTO #t VALUES (2,31,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (2,32,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,32,3761,17,3,9) | |
| INSERT INTO #t VALUES (2,32,3761,18,3,4.13823) | |
| INSERT INTO #t VALUES (2,32,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (2,33,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,33,3761,17,3,17.6667) | |
| INSERT INTO #t VALUES (2,33,3761,18,3,5.93221) | |
| INSERT INTO #t VALUES (2,33,3761,59,3,3.5) | |
| INSERT INTO #t VALUES (2,34,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,34,3761,17,3,48) | |
| INSERT INTO #t VALUES (2,34,3761,18,3,15.0626) | |
| INSERT INTO #t VALUES (2,34,3761,59,3,3.16667) | |
| INSERT INTO #t VALUES (2,35,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,35,3761,17,3,6.2) | |
| INSERT INTO #t VALUES (2,35,3761,18,3,4.68631) | |
| INSERT INTO #t VALUES (2,35,3761,59,3,3) | |
| INSERT INTO #t VALUES (2,36,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (2,36,3761,17,3,9.5) | |
| INSERT INTO #t VALUES (2,36,3761,18,3,14.3411) | |
| INSERT INTO #t VALUES (2,36,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (3,0,3761,17,3,13.1667) | |
| INSERT INTO #t VALUES (3,0,3761,59,3,2.94444) | |
| INSERT INTO #t VALUES (3,1,3761,17,3,15.625) | |
| INSERT INTO #t VALUES (3,1,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (3,2,3761,17,3,12.5833) | |
| INSERT INTO #t VALUES (3,2,3761,59,3,2) | |
| INSERT INTO #t VALUES (3,3,3761,17,3,11.5417) | |
| INSERT INTO #t VALUES (3,3,3761,59,3,1.94444) | |
| INSERT INTO #t VALUES (3,4,3761,17,3,11.65) | |
| INSERT INTO #t VALUES (3,4,3761,59,3,2.55556) | |
| INSERT INTO #t VALUES (3,5,3761,16,3,1) | |
| INSERT INTO #t VALUES (3,5,3761,17,3,14.25) | |
| INSERT INTO #t VALUES (3,5,3761,18,3,4.70604) | |
| INSERT INTO #t VALUES (3,5,3761,59,3,2.77778) | |
| INSERT INTO #t VALUES (3,6,3761,16,3,0.798247) | |
| INSERT INTO #t VALUES (3,6,3761,17,3,13.65) | |
| INSERT INTO #t VALUES (3,6,3761,18,3,8.18721) | |
| INSERT INTO #t VALUES (3,6,3761,59,3,3.83333) | |
| INSERT INTO #t VALUES (3,7,3761,16,3,0.615736) | |
| INSERT INTO #t VALUES (3,7,3761,17,3,12.4) | |
| INSERT INTO #t VALUES (3,7,3761,18,3,8.77411) | |
| INSERT INTO #t VALUES (3,7,3761,59,3,3.88889) | |
| INSERT INTO #t VALUES (3,8,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (3,8,3761,17,3,18.125) | |
| INSERT INTO #t VALUES (3,8,3761,18,3,15.3587) | |
| INSERT INTO #t VALUES (3,8,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (3,9,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (3,9,3761,17,3,12.4167) | |
| INSERT INTO #t VALUES (3,9,3761,18,3,9.74891) | |
| INSERT INTO #t VALUES (3,9,3761,59,3,2.61111) | |
| INSERT INTO #t VALUES (3,10,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (3,10,3761,17,3,9.25) | |
| INSERT INTO #t VALUES (3,10,3761,18,3,11.8727) | |
| INSERT INTO #t VALUES (3,10,3761,59,3,3.27778) | |
| INSERT INTO #t VALUES (3,11,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (3,11,3761,17,3,9.16667) | |
| INSERT INTO #t VALUES (3,11,3761,18,3,3.38896) | |
| INSERT INTO #t VALUES (3,11,3761,59,3,4.16667) | |
| INSERT INTO #t VALUES (3,12,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (3,12,3761,17,3,15.5) | |
| INSERT INTO #t VALUES (3,12,3761,18,3,8.96083) | |
| INSERT INTO #t VALUES (3,12,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (3,13,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (3,13,3761,17,3,8.91667) | |
| INSERT INTO #t VALUES (3,13,3761,18,3,6.42298) | |
| INSERT INTO #t VALUES (3,13,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (3,14,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (3,14,3761,17,3,11.725) | |
| INSERT INTO #t VALUES (3,14,3761,18,3,7.15984) | |
| INSERT INTO #t VALUES (3,14,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (3,15,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,15,3761,17,3,9.48333) | |
| INSERT INTO #t VALUES (3,15,3761,18,3,7.01953) | |
| INSERT INTO #t VALUES (3,15,3761,59,3,2.38889) | |
| INSERT INTO #t VALUES (3,16,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,16,3761,17,3,8.41667) | |
| INSERT INTO #t VALUES (3,16,3761,18,3,9.82449) | |
| INSERT INTO #t VALUES (3,16,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (3,17,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,17,3761,17,3,10.3) | |
| INSERT INTO #t VALUES (3,17,3761,18,3,9.79019) | |
| INSERT INTO #t VALUES (3,17,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (3,18,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,18,3761,17,3,9.75) | |
| INSERT INTO #t VALUES (3,18,3761,18,3,6.89291) | |
| INSERT INTO #t VALUES (3,18,3761,59,3,2.88889) | |
| INSERT INTO #t VALUES (3,19,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,19,3761,17,3,11.35) | |
| INSERT INTO #t VALUES (3,19,3761,18,3,6.31227) | |
| INSERT INTO #t VALUES (3,19,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (3,20,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,20,3761,17,3,12.1667) | |
| INSERT INTO #t VALUES (3,20,3761,18,3,6.52568) | |
| INSERT INTO #t VALUES (3,20,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (3,21,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,21,3761,17,3,8.6) | |
| INSERT INTO #t VALUES (3,21,3761,18,3,7.33854) | |
| INSERT INTO #t VALUES (3,21,3761,59,3,3.41667) | |
| INSERT INTO #t VALUES (3,22,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,22,3761,17,3,16.1111) | |
| INSERT INTO #t VALUES (3,22,3761,18,3,3.36801) | |
| INSERT INTO #t VALUES (3,22,3761,59,3,3.08333) | |
| INSERT INTO #t VALUES (3,23,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,23,3761,17,3,9.83333) | |
| INSERT INTO #t VALUES (3,23,3761,18,3,0.544731) | |
| INSERT INTO #t VALUES (3,23,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (3,24,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,24,3761,17,3,11.8333) | |
| INSERT INTO #t VALUES (3,24,3761,18,3,6.01471) | |
| INSERT INTO #t VALUES (3,24,3761,59,3,2.58333) | |
| INSERT INTO #t VALUES (3,25,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,25,3761,17,3,9.11111) | |
| INSERT INTO #t VALUES (3,25,3761,18,3,6.9671) | |
| INSERT INTO #t VALUES (3,25,3761,59,3,2.33333) | |
| INSERT INTO #t VALUES (3,26,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,26,3761,17,3,8.77778) | |
| INSERT INTO #t VALUES (3,26,3761,18,3,5.42866) | |
| INSERT INTO #t VALUES (3,26,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (3,27,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,27,3761,17,3,21) | |
| INSERT INTO #t VALUES (3,27,3761,18,3,7.19481) | |
| INSERT INTO #t VALUES (3,27,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (3,28,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,28,3761,17,3,8.83333) | |
| INSERT INTO #t VALUES (3,28,3761,18,3,6.48254) | |
| INSERT INTO #t VALUES (3,28,3761,59,3,2.25) | |
| INSERT INTO #t VALUES (3,29,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,29,3761,17,3,8.33333) | |
| INSERT INTO #t VALUES (3,29,3761,18,3,6.35555) | |
| INSERT INTO #t VALUES (3,29,3761,59,3,2.91667) | |
| INSERT INTO #t VALUES (3,30,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,30,3761,17,3,7.8) | |
| INSERT INTO #t VALUES (3,30,3761,18,3,10.0598) | |
| INSERT INTO #t VALUES (3,30,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (3,31,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,31,3761,17,3,12.75) | |
| INSERT INTO #t VALUES (3,31,3761,18,3,4.34086) | |
| INSERT INTO #t VALUES (3,31,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (3,32,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,32,3761,17,3,9) | |
| INSERT INTO #t VALUES (3,32,3761,18,3,2.81427) | |
| INSERT INTO #t VALUES (3,32,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (3,33,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,33,3761,17,3,17.6667) | |
| INSERT INTO #t VALUES (3,33,3761,18,3,4.97522) | |
| INSERT INTO #t VALUES (3,33,3761,59,3,3.5) | |
| INSERT INTO #t VALUES (3,34,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,34,3761,17,3,48) | |
| INSERT INTO #t VALUES (3,34,3761,18,3,5.25169) | |
| INSERT INTO #t VALUES (3,34,3761,59,3,3.16667) | |
| INSERT INTO #t VALUES (3,35,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,35,3761,17,3,6.2) | |
| INSERT INTO #t VALUES (3,35,3761,18,3,4.57999) | |
| INSERT INTO #t VALUES (3,35,3761,59,3,3) | |
| INSERT INTO #t VALUES (3,36,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (3,36,3761,17,3,9.5) | |
| INSERT INTO #t VALUES (3,36,3761,18,3,7.67966) | |
| INSERT INTO #t VALUES (3,36,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (4,0,3761,17,3,13.1667) | |
| INSERT INTO #t VALUES (4,0,3761,59,3,2.94444) | |
| INSERT INTO #t VALUES (4,1,3761,17,3,15.625) | |
| INSERT INTO #t VALUES (4,1,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (4,2,3761,17,3,12.5833) | |
| INSERT INTO #t VALUES (4,2,3761,59,3,2) | |
| INSERT INTO #t VALUES (4,3,3761,17,3,11.5417) | |
| INSERT INTO #t VALUES (4,3,3761,59,3,1.94444) | |
| INSERT INTO #t VALUES (4,4,3761,17,3,11.65) | |
| INSERT INTO #t VALUES (4,4,3761,59,3,2.55556) | |
| INSERT INTO #t VALUES (4,5,3761,16,3,1) | |
| INSERT INTO #t VALUES (4,5,3761,17,3,14.25) | |
| INSERT INTO #t VALUES (4,5,3761,18,3,6.36439) | |
| INSERT INTO #t VALUES (4,5,3761,59,3,2.77778) | |
| INSERT INTO #t VALUES (4,6,3761,16,3,0.896393) | |
| INSERT INTO #t VALUES (4,6,3761,17,3,13.65) | |
| INSERT INTO #t VALUES (4,6,3761,18,3,10.1877) | |
| INSERT INTO #t VALUES (4,6,3761,59,3,3.83333) | |
| INSERT INTO #t VALUES (4,7,3761,16,3,0.790268) | |
| INSERT INTO #t VALUES (4,7,3761,17,3,12.4) | |
| INSERT INTO #t VALUES (4,7,3761,18,3,12.2253) | |
| INSERT INTO #t VALUES (4,7,3761,59,3,3.88889) | |
| INSERT INTO #t VALUES (4,8,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (4,8,3761,17,3,18.125) | |
| INSERT INTO #t VALUES (4,8,3761,18,3,4.09988) | |
| INSERT INTO #t VALUES (4,8,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (4,9,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (4,9,3761,17,3,12.4167) | |
| INSERT INTO #t VALUES (4,9,3761,18,3,2.05559) | |
| INSERT INTO #t VALUES (4,9,3761,59,3,2.61111) | |
| INSERT INTO #t VALUES (4,10,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (4,10,3761,17,3,9.25) | |
| INSERT INTO #t VALUES (4,10,3761,18,3,3.96633) | |
| INSERT INTO #t VALUES (4,10,3761,59,3,3.27778) | |
| INSERT INTO #t VALUES (4,11,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (4,11,3761,17,3,9.16667) | |
| INSERT INTO #t VALUES (4,11,3761,18,3,-0.727102) | |
| INSERT INTO #t VALUES (4,11,3761,59,3,4.16667) | |
| INSERT INTO #t VALUES (4,12,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (4,12,3761,17,3,15.5) | |
| INSERT INTO #t VALUES (4,12,3761,18,3,8.39798) | |
| INSERT INTO #t VALUES (4,12,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (4,13,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (4,13,3761,17,3,8.91667) | |
| INSERT INTO #t VALUES (4,13,3761,18,3,7.28558) | |
| INSERT INTO #t VALUES (4,13,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (4,14,3761,16,3,0.487084) | |
| INSERT INTO #t VALUES (4,14,3761,17,3,11.725) | |
| INSERT INTO #t VALUES (4,14,3761,18,3,1.82688) | |
| INSERT INTO #t VALUES (4,14,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (4,15,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,15,3761,17,3,9.48333) | |
| INSERT INTO #t VALUES (4,15,3761,18,3,3.80933) | |
| INSERT INTO #t VALUES (4,15,3761,59,3,2.38889) | |
| INSERT INTO #t VALUES (4,16,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,16,3761,17,3,8.41667) | |
| INSERT INTO #t VALUES (4,16,3761,18,3,4.87648) | |
| INSERT INTO #t VALUES (4,16,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (4,17,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,17,3761,17,3,10.3) | |
| INSERT INTO #t VALUES (4,17,3761,18,3,1.79595) | |
| INSERT INTO #t VALUES (4,17,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (4,18,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,18,3761,17,3,9.75) | |
| INSERT INTO #t VALUES (4,18,3761,18,3,6.88314) | |
| INSERT INTO #t VALUES (4,18,3761,59,3,2.88889) | |
| INSERT INTO #t VALUES (4,19,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,19,3761,17,3,11.35) | |
| INSERT INTO #t VALUES (4,19,3761,18,3,9.01615) | |
| INSERT INTO #t VALUES (4,19,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (4,20,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,20,3761,17,3,12.1667) | |
| INSERT INTO #t VALUES (4,20,3761,18,3,13.9774) | |
| INSERT INTO #t VALUES (4,20,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (4,21,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,21,3761,17,3,8.6) | |
| INSERT INTO #t VALUES (4,21,3761,18,3,12.9111) | |
| INSERT INTO #t VALUES (4,21,3761,59,3,3.41667) | |
| INSERT INTO #t VALUES (4,22,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,22,3761,17,3,16.1111) | |
| INSERT INTO #t VALUES (4,22,3761,18,3,18.5948) | |
| INSERT INTO #t VALUES (4,22,3761,59,3,3.08333) | |
| INSERT INTO #t VALUES (4,23,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,23,3761,17,3,9.83333) | |
| INSERT INTO #t VALUES (4,23,3761,18,3,13.5533) | |
| INSERT INTO #t VALUES (4,23,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (4,24,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,24,3761,17,3,11.8333) | |
| INSERT INTO #t VALUES (4,24,3761,18,3,8.25211) | |
| INSERT INTO #t VALUES (4,24,3761,59,3,2.58333) | |
| INSERT INTO #t VALUES (4,25,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,25,3761,17,3,9.11111) | |
| INSERT INTO #t VALUES (4,25,3761,18,3,-1.62189) | |
| INSERT INTO #t VALUES (4,25,3761,59,3,2.33333) | |
| INSERT INTO #t VALUES (4,26,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,26,3761,17,3,8.77778) | |
| INSERT INTO #t VALUES (4,26,3761,18,3,3.49406) | |
| INSERT INTO #t VALUES (4,26,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (4,27,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,27,3761,17,3,21) | |
| INSERT INTO #t VALUES (4,27,3761,18,3,2.89757) | |
| INSERT INTO #t VALUES (4,27,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (4,28,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,28,3761,17,3,8.83333) | |
| INSERT INTO #t VALUES (4,28,3761,18,3,1.89373) | |
| INSERT INTO #t VALUES (4,28,3761,59,3,2.25) | |
| INSERT INTO #t VALUES (4,29,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,29,3761,17,3,8.33333) | |
| INSERT INTO #t VALUES (4,29,3761,18,3,9.80069) | |
| INSERT INTO #t VALUES (4,29,3761,59,3,2.91667) | |
| INSERT INTO #t VALUES (4,30,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,30,3761,17,3,7.8) | |
| INSERT INTO #t VALUES (4,30,3761,18,3,-3.24917) | |
| INSERT INTO #t VALUES (4,30,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (4,31,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,31,3761,17,3,12.75) | |
| INSERT INTO #t VALUES (4,31,3761,18,3,15.8823) | |
| INSERT INTO #t VALUES (4,31,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (4,32,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,32,3761,17,3,9) | |
| INSERT INTO #t VALUES (4,32,3761,18,3,2.14066) | |
| INSERT INTO #t VALUES (4,32,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (4,33,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,33,3761,17,3,17.6667) | |
| INSERT INTO #t VALUES (4,33,3761,18,3,2.66123) | |
| INSERT INTO #t VALUES (4,33,3761,59,3,3.5) | |
| INSERT INTO #t VALUES (4,34,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,34,3761,17,3,48) | |
| INSERT INTO #t VALUES (4,34,3761,18,3,14.748) | |
| INSERT INTO #t VALUES (4,34,3761,59,3,3.16667) | |
| INSERT INTO #t VALUES (4,35,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,35,3761,17,3,6.2) | |
| INSERT INTO #t VALUES (4,35,3761,18,3,4.28973) | |
| INSERT INTO #t VALUES (4,35,3761,59,3,3) | |
| INSERT INTO #t VALUES (4,36,3761,16,3,0.21267) | |
| INSERT INTO #t VALUES (4,36,3761,17,3,9.5) | |
| INSERT INTO #t VALUES (4,36,3761,18,3,17.754) | |
| INSERT INTO #t VALUES (4,36,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (5,0,3761,17,3,13.1667) | |
| INSERT INTO #t VALUES (5,0,3761,59,3,2.94444) | |
| INSERT INTO #t VALUES (5,1,3761,17,3,15.625) | |
| INSERT INTO #t VALUES (5,1,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (5,2,3761,17,3,12.5833) | |
| INSERT INTO #t VALUES (5,2,3761,59,3,2) | |
| INSERT INTO #t VALUES (5,3,3761,17,3,11.5417) | |
| INSERT INTO #t VALUES (5,3,3761,59,3,1.94444) | |
| INSERT INTO #t VALUES (5,4,3761,17,3,11.65) | |
| INSERT INTO #t VALUES (5,4,3761,59,3,2.55556) | |
| INSERT INTO #t VALUES (5,5,3761,16,3,1) | |
| INSERT INTO #t VALUES (5,5,3761,17,3,14.25) | |
| INSERT INTO #t VALUES (5,5,3761,18,3,6.57583) | |
| INSERT INTO #t VALUES (5,5,3761,59,3,2.77778) | |
| INSERT INTO #t VALUES (5,6,3761,16,3,0.798247) | |
| INSERT INTO #t VALUES (5,6,3761,17,3,13.65) | |
| INSERT INTO #t VALUES (5,6,3761,18,3,7.73611) | |
| INSERT INTO #t VALUES (5,6,3761,59,3,3.83333) | |
| INSERT INTO #t VALUES (5,7,3761,16,3,0.615736) | |
| INSERT INTO #t VALUES (5,7,3761,17,3,12.4) | |
| INSERT INTO #t VALUES (5,7,3761,18,3,9.46755) | |
| INSERT INTO #t VALUES (5,7,3761,59,3,3.88889) | |
| INSERT INTO #t VALUES (5,8,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (5,8,3761,17,3,18.125) | |
| INSERT INTO #t VALUES (5,8,3761,18,3,9.44449) | |
| INSERT INTO #t VALUES (5,8,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (5,9,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (5,9,3761,17,3,12.4167) | |
| INSERT INTO #t VALUES (5,9,3761,18,3,6.57282) | |
| INSERT INTO #t VALUES (5,9,3761,59,3,2.61111) | |
| INSERT INTO #t VALUES (5,10,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (5,10,3761,17,3,9.25) | |
| INSERT INTO #t VALUES (5,10,3761,18,3,7.72625) | |
| INSERT INTO #t VALUES (5,10,3761,59,3,3.27778) | |
| INSERT INTO #t VALUES (5,11,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (5,11,3761,17,3,9.16667) | |
| INSERT INTO #t VALUES (5,11,3761,18,3,6.62303) | |
| INSERT INTO #t VALUES (5,11,3761,59,3,4.16667) | |
| INSERT INTO #t VALUES (5,12,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (5,12,3761,17,3,15.5) | |
| INSERT INTO #t VALUES (5,12,3761,18,3,6.4347) | |
| INSERT INTO #t VALUES (5,12,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (5,13,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (5,13,3761,17,3,8.91667) | |
| INSERT INTO #t VALUES (5,13,3761,18,3,6.14058) | |
| INSERT INTO #t VALUES (5,13,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (5,14,3761,16,3,0.227195) | |
| INSERT INTO #t VALUES (5,14,3761,17,3,11.725) | |
| INSERT INTO #t VALUES (5,14,3761,18,3,8.15348) | |
| INSERT INTO #t VALUES (5,14,3761,59,3,2.11111) | |
| INSERT INTO #t VALUES (5,15,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,15,3761,17,3,9.48333) | |
| INSERT INTO #t VALUES (5,15,3761,18,3,6.41548) | |
| INSERT INTO #t VALUES (5,15,3761,59,3,2.38889) | |
| INSERT INTO #t VALUES (5,16,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,16,3761,17,3,8.41667) | |
| INSERT INTO #t VALUES (5,16,3761,18,3,8.12079) | |
| INSERT INTO #t VALUES (5,16,3761,59,3,3.22222) | |
| INSERT INTO #t VALUES (5,17,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,17,3761,17,3,10.3) | |
| INSERT INTO #t VALUES (5,17,3761,18,3,8.08516) | |
| INSERT INTO #t VALUES (5,17,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (5,18,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,18,3761,17,3,9.75) | |
| INSERT INTO #t VALUES (5,18,3761,18,3,5.24447) | |
| INSERT INTO #t VALUES (5,18,3761,59,3,2.88889) | |
| INSERT INTO #t VALUES (5,19,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,19,3761,17,3,11.35) | |
| INSERT INTO #t VALUES (5,19,3761,18,3,5.85937) | |
| INSERT INTO #t VALUES (5,19,3761,59,3,2.44444) | |
| INSERT INTO #t VALUES (5,20,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,20,3761,17,3,12.1667) | |
| INSERT INTO #t VALUES (5,20,3761,18,3,7.58443) | |
| INSERT INTO #t VALUES (5,20,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (5,21,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,21,3761,17,3,8.6) | |
| INSERT INTO #t VALUES (5,21,3761,18,3,5.353) | |
| INSERT INTO #t VALUES (5,21,3761,59,3,3.41667) | |
| INSERT INTO #t VALUES (5,22,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,22,3761,17,3,16.1111) | |
| INSERT INTO #t VALUES (5,22,3761,18,3,5.42111) | |
| INSERT INTO #t VALUES (5,22,3761,59,3,3.08333) | |
| INSERT INTO #t VALUES (5,23,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,23,3761,17,3,9.83333) | |
| INSERT INTO #t VALUES (5,23,3761,18,3,5.83401) | |
| INSERT INTO #t VALUES (5,23,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (5,24,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,24,3761,17,3,11.8333) | |
| INSERT INTO #t VALUES (5,24,3761,18,3,4.9117) | |
| INSERT INTO #t VALUES (5,24,3761,59,3,2.58333) | |
| INSERT INTO #t VALUES (5,25,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,25,3761,17,3,9.11111) | |
| INSERT INTO #t VALUES (5,25,3761,18,3,7.85524) | |
| INSERT INTO #t VALUES (5,25,3761,59,3,2.33333) | |
| INSERT INTO #t VALUES (5,26,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,26,3761,17,3,8.77778) | |
| INSERT INTO #t VALUES (5,26,3761,18,3,5.86464) | |
| INSERT INTO #t VALUES (5,26,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (5,27,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,27,3761,17,3,21) | |
| INSERT INTO #t VALUES (5,27,3761,18,3,7.65866) | |
| INSERT INTO #t VALUES (5,27,3761,59,3,2.66667) | |
| INSERT INTO #t VALUES (5,28,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,28,3761,17,3,8.83333) | |
| INSERT INTO #t VALUES (5,28,3761,18,3,6.43542) | |
| INSERT INTO #t VALUES (5,28,3761,59,3,2.25) | |
| INSERT INTO #t VALUES (5,29,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,29,3761,17,3,8.33333) | |
| INSERT INTO #t VALUES (5,29,3761,18,3,5.73212) | |
| INSERT INTO #t VALUES (5,29,3761,59,3,2.91667) | |
| INSERT INTO #t VALUES (5,30,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,30,3761,17,3,7.8) | |
| INSERT INTO #t VALUES (5,30,3761,18,3,8.25) | |
| INSERT INTO #t VALUES (5,30,3761,59,3,2.83333) | |
| INSERT INTO #t VALUES (5,31,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,31,3761,17,3,12.75) | |
| INSERT INTO #t VALUES (5,31,3761,18,3,7.16648) | |
| INSERT INTO #t VALUES (5,31,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (5,32,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,32,3761,17,3,9) | |
| INSERT INTO #t VALUES (5,32,3761,18,3,6.54287) | |
| INSERT INTO #t VALUES (5,32,3761,59,3,3.33333) | |
| INSERT INTO #t VALUES (5,33,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,33,3761,17,3,17.6667) | |
| INSERT INTO #t VALUES (5,33,3761,18,3,9.74845) | |
| INSERT INTO #t VALUES (5,33,3761,59,3,3.5) | |
| INSERT INTO #t VALUES (5,34,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,34,3761,17,3,48) | |
| INSERT INTO #t VALUES (5,34,3761,18,3,6.8651) | |
| INSERT INTO #t VALUES (5,34,3761,59,3,3.16667) | |
| INSERT INTO #t VALUES (5,35,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,35,3761,17,3,6.2) | |
| INSERT INTO #t VALUES (5,35,3761,18,3,5.29325) | |
| INSERT INTO #t VALUES (5,35,3761,59,3,3) | |
| INSERT INTO #t VALUES (5,36,3761,16,3,0.0412036) | |
| INSERT INTO #t VALUES (5,36,3761,17,3,9.5) | |
| INSERT INTO #t VALUES (5,36,3761,18,3,4.51036) | |
| INSERT INTO #t VALUES (5,36,3761,59,3,3.33333) | |
| GO | |
| -- Performing a SUM() over 1500 rows, each of which has the n 0 or 1, overflows the INT data type in the batch mode Window Aggregate | |
| --Msg 8115, Level 16, State 2, Line 1521 | |
| --Arithmetic overflow error converting expression to data type int. | |
| SELECT a, p, s, v, m, n, SUM(CASE WHEN n IS NULL THEN 0 ELSE 1 END) OVER (PARTITION BY s, v, a ORDER BY p) AS lastNonNullPartition | |
| FROM ( | |
| SELECT a, p, s, v, m, n, RANK() OVER (PARTITION BY v, s, a, p ORDER BY m) AS rank | |
| FROM #t | |
| ) x | |
| WHERE x.rank = 1 | |
| GO | |
| -- Executes successfully if we hint a parallel plan | |
| SELECT a, p, s, v, m, n, SUM(CASE WHEN n IS NULL THEN 0 ELSE 1 END) OVER (PARTITION BY s, v, a ORDER BY p) AS lastNonNullPartition | |
| FROM ( | |
| SELECT a, p, s, v, m, n, RANK() OVER (PARTITION BY v, s, a, p ORDER BY m) AS rank | |
| FROM #t | |
| ) x | |
| WHERE x.rank = 1 | |
| OPTION (QUERYTRACEON 8649/* Prefer a parallel plan, regardless of cost threshold for parallelism */) | |
| GO | |
| -- Also executes successfully if we force row mode | |
| --Msg 8115, Level 16, State 2, Line 1521 | |
| --Arithmetic overflow error converting expression to data type int. | |
| SELECT a, p, s, v, m, n, SUM(CASE WHEN n IS NULL THEN 0 ELSE 1 END) OVER (PARTITION BY s, v, a ORDER BY p) AS lastNonNullPartition | |
| FROM ( | |
| SELECT a, p, s, v, m, n, RANK() OVER (PARTITION BY v, s, a, p ORDER BY m) AS rank | |
| FROM #t | |
| ) x | |
| WHERE x.rank = 1 | |
| OPTION (QUERYTRACEON 9453/* Disable batch mode */) | |
| GO | |
| -- Also executes successfully if we use COUNT() rather than SUM to count the ns | |
| -- (But such a simplification isn't always possible depending on the business logic) | |
| SELECT a, p, s, v, m, n, COUNT(n) OVER (PARTITION BY s, v, a ORDER BY p) AS lastNonNullPartition | |
| FROM ( | |
| SELECT a, p, s, v, m, n, RANK() OVER (PARTITION BY v, s, a, p ORDER BY m) AS rank | |
| FROM #t | |
| ) x | |
| WHERE x.rank = 1 | |
| GO |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment