Viewing 15 posts - 16 through 30 (of 167 total)
Jeff
what does 'v' means in this code?
... SELECT SomeInt,SomeDecimal
FROM (VALUES (1,1),(
December 18, 2018 at 11:00 am
Jeff I created the script - it is 17 Mb - 45 000 records, table with 5 fields. Not sure that we need to continue at this point - we have...
December 18, 2018 at 10:43 am
December 18, 2018 at 8:41 am
Sorry .... which index should it be?
BTW, I can send you a chunk of data in Excel ... if you have time and want to continue the research ...
December 18, 2018 at 7:13 am
Tried Offset/Fetch - works slower than Percentile ...
December 17, 2018 at 12:28 pm
Naïve question. In the original line of my associate (she's testing our SS 2008 codes on SS 2016 where we are migrating soon)
PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY [recordvalue]) OVER...
December 17, 2018 at 8:24 am
December 16, 2018 at 7:00 pm
Yes, it is PERCENTILE_CONT(0.5)...
December 16, 2018 at 6:41 pm
PERCENTILE_DISC (0.5) does not provide the median for EVEN number of records. Only for ODD number of records. Actually this is the same as MAX (Select 50 percent ... -...
December 16, 2018 at 12:50 pm
Test result (table has 4 records: 1,2,3,4):
Select
December 16, 2018 at 10:44 am
Viewing 15 posts - 16 through 30 (of 167 total)