• Interests: Fast Computers, Fast Cars

MEDIAN sp for SQL 2000

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 […]

2007-02-23 (first published: )

640 reads

Blogs

Updated Pluralsight Course – Managing the Kubernetes API Server and Pods

By

My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...

Daily Coping 11 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

What do you do when technology changes? : T-SQL Tuesday #138

By

Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...

Read the latest Blogs

Forums

Where to download previous versions of CU for SQL server 2019

By sqlfriend

I see there is some defects for inline functions by CU9, and CU10. So...

How to rebuild index on Internal Table?

By mandavli

I keep on getting error : Unable to find index entry in index ID...

Division between two Summed fields giving errors

By fahad.kazi

Hi, I am trying to get a Percentage of Budget field added to my...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers