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.
Declare @YourTable Table ([idMetaData] int,[TimeStamp] varchar(50),[SampleNumber] int,[ChannelValue] decimal(18,10))
Insert Into @YourTable Values
(3,'0,5036500',12073,0.4573468975)
,(3,'0,5037000',12074,0.4418814526)
,(3,'0,5037500',12075,0.4109505628)
,(3,'0,5038000',12076,0.4109505628)
,(3,'0,5038500',12077,0.4264160077)
,(3,'0,5038999',12078,0.4573468975)
,(3,'0,5039499',12079,0.4573468975)
,(3,'0,5039999',12080,0.4109505628)
,(3,'0,5040500',12081,0.3336233382)
,(3,'0,5041000',12082,0.2408306686)
,(3,'0,5041500',12083,0.1789688889)
,(3,'0,5042000',12084,0.1789688889)
,(3,'0,5042500',12085,0.2253652237)
,(3,'0,5042999',12086,0.3026924483)
,(3,'0,5043499',12087,0.3645542280)
,(3,'0,5044000',12088,0.3954851178)
,(3,'0,5044500',12089,0.3645542280)
,(3,'0,5045000',12090,0.3026924483)
,(3,'0,5045500',12091,0.2253652237)
,(3,'0,5046000',12092,0.1635034440)
,(3,'0,5046499',12093,0.1325725541)
,(3,'0,5046999',12094,0.1480379991)
,(3,'0,5047500',12095,0.1789688889)
,(3,'0,5048000',12096,0.1944343338)
,(3,'0,5048500',12097,0.2098997788)
,(3,'0,5049000',12098,0.1944343338)
,(3,'0,5049500',12099,0.1635034440)
,(3,'0,5049999',12100,0.1171071092)
,(3,'0,5050499',12101,0.0861762194)
,(3,'0,5051000',12102,0.0707107744)
,(3,'0,5051500',12103,0.0707107744)
,(3,'0,5052000',12104,0.0861762194)
,(3,'0,5052500',12105,0.1171071092)
,(3,'0,5053000',12106,0.1635034440)
idMetaData Bin TimeStamp1 TimeStamp2 SampleNumber1 SampleNumber2 Records StartValue EndValue UniqueVals MinVal MaxVal Mean Median ModeR1 ModeR2 StdDev
3 1 0,5036500 0,5040500 12073 12081 9 0.4573468975 0.3336233382 5 0.3336233382 0.4573468975 0.4229792421 0.4264160077 0.4573468975 0.4573468975 0.0392604398083304
3 2 0,5041000 0,5045500 12082 12091 10 0.2408306686 0.2253652237 6 0.1789688889 0.3954851178 0.2779477364 0.2779477364 0.1789688889 0.1789688889 0.0792619769046758
3 3 0,5046000 0,5050499 12092 12101 10 0.1635034440 0.0861762194 8 0.0861762194 0.2098997788 0.1588638105 0.1588638105 0.1944343338 0.1944343338 0.0386120264086292
3 4 0,5051000 0,5053000 12102 12106 5 0.0707107744 0.1635034440 4 0.0707107744 0.1635034440 0.1016416642 0.1016416642 0.0707107744 0.0707107744 0.0394293027441935
15 1 0,3148000 0,3152000 8296 8304 9 1.5081626404 1.4920187367 6 1.4274431217 1.5727382554 1.4974000379 1.4920187367 1.5081626404 1.5081626404 0.0427127545043947
15 2 0,3152500 0,3157000 8305 8314 10 1.5081626404 1.4758748329 7 1.3951553142 1.5727382554 1.5097770307 1.5097770307 1.5081626404 1.5081626404 0.0501645814410561
15 3 0,3157500 0,3162000 8315 8324 10 1.4435870254 1.5888821591 7 1.4274431217 1.5888821591 1.4855611751 1.4855611751 1.4274431217 1.4274431217 0.0539205310797609
15 4 0,3162500 0,3165000 8325 8330 6 1.5565943516 1.5404504479 3 1.5243065442 1.5565943516 1.5404504479 1.5404504479 1.5404504479 1.5404504479 0.0102103012037006
50 1 0,8799999 0,8803999 19600 19608 9 -0.7106432894 -0.8617764701 7 -0.8617764701 -0.6098878356 -0.7148414332 -0.6098878356 -0.7232377211 -0.7232377211 0.0840153385705176
50 2 0,8804500 0,8809000 19609 19618 10 -0.8491820384 -0.7484265845 8 -0.8617764701 -0.5972934038 -0.7572426867 -0.7572426867 -0.6602655625 -0.6602655625 0.0894608608028592
50 3 0,8809500 0,8813999 19619 19628 10 -0.8365876066 -0.8491820384 9 -0.8491820384 -0.6980488576 -0.7799126638 -0.7799126638 -0.7232377211 -0.7232377211 0.0531856951801327
50 4 0,8814499 0,8819000 19629 19638 10 -0.8617764701 -0.7232377211 7 -0.8617764701 -0.6728599942 -0.7849504365 -0.7849504365 -0.7232377211 -0.7232377211 0.0606773411106349
50 5 0,8819500 0,8824000 19639 19648 10 -0.7610210163 -0.7988043114 9 -0.8869653335 -0.6602655625 -0.7622804594 -0.7622804594 -0.6602655625 -0.6602655625 0.0825765409023701
50 6 0,8824499 0,8828999 19649 19658 10 -0.8491820384 -0.6980488576 6 -0.8491820384 -0.6728599942 -0.7408699255 -0.7408699255 -0.7232377211 -0.7232377211 0.0658988253831109
50 7 0,8829499 0,8834000 19659 19668 10 -0.6980488576 -0.8617764701 8 -0.8617764701 -0.6854544259 -0.7547238004 -0.7547238004 -0.7610210163 -0.7610210163 0.0515021751820596
50 8 0,8834500 0,8838999 19669 19678 10 -0.9121541970 -0.7484265845 9 -0.9121541970 -0.6980488576 -0.8164365158 -0.8164365158 -0.9121541970 -0.9121541970 0.0814483197067547
50 9 0,8839499 0,8844000 19679 19688 10 -0.8491820384 -0.6728599942 8 -0.8491820384 -0.6728599942 -0.7569832435 -0.7569832435 -0.8491820384 -0.8491820384 0.0582890176359667
50 10 0,8844500 0,8846499 19689 19693 5 -0.6854544259 -0.7862098797 4 -0.7862098797 -0.6854544259 -0.7383510391 -0.7383510391 -0.7862098797 -0.7862098797 0.0457578427965903