• Interests: Fast Computers, Fast Cars

Technical Article

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

You rated this post out of 5. Change rating

2007-02-23 (first published: )

651 reads

Blogs

March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios

By

If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...

SQL Saturday Atlanta BI Recap

By

https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...

Mistakes IT Shops Without a DBA Make

By

We get it. There’s no budget for a DBA on staff, or even a...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

SQL 2017 server keeps locking up

By karenhallard

I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...

Alternatiives to Junk Dimensions

By Lord Slaagh

Hello SSC, I am not sure if I posted this in the right spot,...

Visit the forum

Question of the Day

Partial Backups II

What is a partial backup for a read-write database?

See possible answers