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!

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

rreturning sp_who data sorted

Status
Not open for further replies.

sodakotahusker

Programmer
Mar 15, 2001
601
Is there a way to select the results from a stored procedure so a sort order can be specified?
 
You can insert/exec the stored procedure in to a temp table and then select from the temp table with a sort order.

Let me know if you have any trouble implementing this.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
I was not aware you could do that! I muddled through it and now this is doing what I wanted. Thanks a million!
Don
 
I'm glad that my advice was helpful.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top