Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Extending Math Functions

3 posts in Product Futures Discussion Last posting was on 2002-03-13 03:27:57.0Z
Rod_Higgins Posted on 2002-03-12 08:47:20.0Z
From: Rod_Higgins
Date: Tue, 12 Mar 2002 03:47:20 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Extending Math Functions
Message-ID: <153C5C881BCEB94A0030475585256B7A.0030477885256B7A@webforums>
Lines: 10
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:690
Article PK: 94223

Hi,

Has anyone out there written a stored procedure to return a median and
standard deviation value from a large table??

Any help appreciated,

Regards
Rod Higgins
rhigg@doh.health.nsw.gov.au


Bret Halford Posted on 2002-03-12 16:19:34.0Z
Message-ID: <3C8E2A96.A27508AD@sybase.com>
Date: Tue, 12 Mar 2002 09:19:34 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Extending Math Functions
References: <153C5C881BCEB94A0030475585256B7A.0030477885256B7A@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 11
NNTP-Posting-Host: 10.22.120.97
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:682
Article PK: 94208

Do a search for "sybase standard deviation" and "sybase median" at
http://www.google.com,
there are solutions for both out there.

-bret

Rod_Higgins wrote:

> Hi,
>
> Has anyone out there written a stored procedure to return a median and
> standard deviation value from a large table??
>
> Any help appreciated,
>
> Regards
> Rod Higgins
> rhigg@doh.health.nsw.gov.au


Rod_Higgins Posted on 2002-03-13 03:27:57.0Z
From: Rod_Higgins
Date: Tue, 12 Mar 2002 22:27:57 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: Extending Math Functions
Message-ID: <1A013E327C9DE95C001309DD85256B7B.005D574685256B7A@webforums>
References: <153C5C881BCEB94A0030475585256B7A.0030477885256B7A@webforums> <3C8E2A96.A27508AD@sybase.com>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:679
Article PK: 94213

Thanks Bret,

I was actually looking for some sql to generate it as a stored procedure,
I'm not really interested in using a third party product. I spent so much
time looking for the sql I just decided to write it myself. It actually
didn't take that long to do,

Regards
Rod Higgins