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 |