The output param is an excellent approach.

CREATE PROCEDURE up_MyProc

--Create output param

@MyAverage money output

AS

SET @MyAverage = SELECT AVG(YourColumn) FROM (YourTable)

In your ASP code you need to create a command object and...

SSC has a massively important point. If you have a clustered index that isn't naturally sequenced in the same way that values the field arrive at the database then...

Great thread. I came to look for an answer to just this question and I appreciate all of the insights everyone provided. I can really stand to have...

Thanks much for the response. I'll try the link.

I teach at the University of Central Florida in Orlando. You can check my course page at http://systems.bus.ucf.edu/lwest....

I'm pretty new to this level of analysis (hence the question).  But the question comes from my work with triggers where an Update gives you access to the deleted and...

Thanks, this was very helpful.  Expanded your example a bit to give me the column outputs I want:

select top 10 sysobjects.id AS [ID], sysobjects.name AS [SP Name],

  colid as Chunk,

 ...