Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MEDIAN Function/Stored Procedure

Status
Not open for further replies.
michaelkrauklis

michaelkrauklis

Programmer
Dec 5, 2001
226
US
Is there any way to create a funciton or stored procedure that can take a result set and return the median? Eg:
Code: 
select company, MEDIAN(salary)
from jobs
group by company
The main problem is passing a result set to a function or stored procedure. Is this possible? For efficiency purposes I can't pull the data out and then calculate the median, and I'd rather not do the query multiple times and use a cursor to pull out the medians for each grouping. Any help will be greatly appreciated.
MYenigmaSELF:-9
myenigmaself@myenigmaself.gaiden.com
"If debugging is the process of removing bugs, then programming must be the process of putting them in." --Dykstra
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
1K
mikrom
mikrom
briangriffin
  • Locked
  • Question
Function Returning Rowcounts
Replies
1
Views
300
briangriffin
briangriffin
Auguy
  • Locked
  • Question
Convert Code to a Function 1
Replies
7
Views
432
Auguy
Auguy
Cpreston
  • Locked
  • Question
Field change as caused issues to store procedure
Replies
19
Views
649
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
Passing TVP instead of Individual Parameters to Procedure
Replies
0
Views
208
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top