MEDIAN sp for SQL 2000

By Lukas Botha, 2007/02/23

Total article views: 201 | Views in the last 30 days: 30

Rate this |

Join the discussion |

Briefcase

I wrote this to calculate the median on a record set. All you need to pass is the table name and column name. If you would like to filter the record set, create a view that displays the correct record.

The limitation of not being able to pass arrays to Stored procedure or functions was the primary reason for creating it in this way.

By Lukas Botha, 2007/02/23

Total article views: 201 | Views in the last 30 days: 30

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Auto generate sp's for any table * usp_create_sps

By spongemagnet | Category: Miscellaneous

| 148 reads

Change the probability of the pseudo-random values

By Peter Petrov | Category: Miscellaneous

| 168 reads

Create an OLAP Main DateTime table

By BillyWilly | Category: Miscellaneous

| 281 reads

Load data from text file with variable columns

By Edgardo Valdez | Category: T-SQL Aids

| 426 reads

Like this? Try these...

Review of ApexSQL Report v4.3

By Mike Pearson

| 4,754 reads

Using Indexed Computed Columns to Improve Performance

By Additional Articles | Category: Performance Tuning

Rate this | 2,691 reads

Count elapsed business days between two dates

By Additional Articles | Category: T-SQL Aids

| 50 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com