|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Median
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Carl Eriksson 2002-11-28, 11:23 am |
| Hi
I need some statistical values from a SQL Server 2000 db.
Avg, StDev etc is no problem (as aggregate functions), but
I do not find a way to get the median.
Does anyone have an idea?
Thanks
/Carl
| |
| Allan Mitchell 2002-11-28, 11:23 am |
| Check out the article in SQL Server Professional Magazine by Tom Moreau
(02/01)
www.pinnaclepublishing.com/sq
--
Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Carl Eriksson" <carl.eriksson@direkt.se> wrote in message
news:1d10f01c296fb$fd1c8e60$8d
f82ecf@TK2MSFTNGXA02...
> Hi
>
> I need some statistical values from a SQL Server 2000 db.
> Avg, StDev etc is no problem (as aggregate functions), but
> I do not find a way to get the median.
> Does anyone have an idea?
>
> Thanks
>
> /Carl
>
| |
| Carl Eriksson 2002-11-28, 12:23 pm |
| Many thanks! /Carl
>-----Original Message-----
>Check out the article in SQL Server Professional
Magazine by Tom Moreau
>(02/01)
>www.pinnaclepublishing.com/sq
>
>
>
>--
>
>
>
>Allan Mitchell (Microsoft SQL Server MVP)
>www.SQLDTS.com
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>
>
>"Carl Eriksson" <carl.eriksson@direkt.se> wrote in
message
> news:1d10f01c296fb$fd1c8e60$8d
f82ecf@TK2MSFTNGXA02...
>> Hi
>>
>> I need some statistical values from a SQL Server 2000
db.
>> Avg, StDev etc is no problem (as aggregate functions),
but
>> I do not find a way to get the median.
>> Does anyone have an idea?
>>
>> Thanks
>>
>> /Carl
>>
>
>
>.
>
|
|
|
|
|