Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ADO Recordset

Author  Topic 

Scott
Posting Yak Master

145 Posts

Posted - 2002-05-21 : 07:35:12
using the pubs database:
select stor_id, ord_num, ord_date, qty
from sales where stor_id = 7131
compute sum(qty), max(qty), min(qty), avg(qty), stdev(qty)

When accessing the recordset I can only get hold of the table values, how do I get to the computed values?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-21 : 07:41:17
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15742

Go to Top of Page
   

- Advertisement -