Very Computer

This is a pseudo-code example of the query:

CREATE PROCEDURE GetPoints

SELECT Lat, Long, Picture
FROM PointDB

---- After running the query, I would like to query the result set
 SELECT AVG(Lat), AVG(Long)
    FROM [above recordset]

Is this possible?  A temporary table would work, but it seems
redundant.

Thanks,
Chuck

I am trying to create a stored procedure that runs a query on a large
database of points in an area.  In addition to the recordset of
points, I would like to return, in output parameters,  the average
latitude and longitude of the set of returned points in order to
generate a map that is centered around all the points.

This is a pseudo-code example of the query:

CREATE PROCEDURE GetPoints

SELECT Lat, Long, Picture
FROM PointDB

---- After running the query, I would like to query the result set
 SELECT AVG(Lat), AVG(Long)
    FROM [above recordset]

Is this possible?  A temporary table would work, but it seems
redundant.

Thanks,
Chuck

just run another query to set the outputs...

CREATE PROCEDURE GetPoints






as
set nocount on
SELECT Lat, Long, Picture
FROM PointDB

---- After running the query, I would like to query the result set

FROM PointDB

--
-oj
http://rac4sql.home.attbi.com

SELECT AVG(a.Lat), AVG(a.Long)
    FROM(
SELECT Lat, Long, Picture
FROM PointDB

--
hth
Hirantha S. Hettiarachchi MCSD,MCDBA,OCP

Please reply only to the newsgroups.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/

Chuck,

SELECT AVG(a.Lat), AVG(a.Long)
    FROM(
SELECT Lat, Long, Picture
FROM PointDB

--
hth
Hirantha S. Hettiarachchi MCSD,MCDBA,OCP

Please reply only to the newsgroups.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

--
-oj
http://rac4sql.home.attbi.com

This idea of running two queries occured to me: it's clearer to read.
However, it's an expensive query, requiring a full table scan.  I
didn't want to do it twice.  I wondered if SQL Server would optimize
this query internally to avoid running the query twice?

--
-oj
http://rac4sql.home.attbi.com