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
 Other Forums
 Other Topics
 Handling multi-recordset returns in COMPUTE clause

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-08 : 00:09:45
Michelle writes "I have a problem dealing with result sets returning multiple numbers of recordset.

I wrote a "SELECT" statment that uses COMPUTE BY clause. Of course depening on the COMPUTE BY clause, I get sets of individual records and its SUM results. I'm trying to refer to the SUM-ed results in ASP, but I just can't seem to refer to it. I've been spending couple of days looking through references and I can see my multiple recordset results in my SQL Server Query Analyzer, but I just can't figure out how to refer to them. Can you help me?

Desperately seeking answers,

Michelle"
   

- Advertisement -