SqlDataReader and COMPUTE clause

[Guest]

I'm working with a SqlDataReader returned by a SqlCommand.ExecuteReader()
that calls a SQL Server 2000 stored procedure that produces multiple result
sets. One of the SELECT statements in the procedure has a COMPUTE clause.

The stored procedure, when executed within SQL Query Analyzer works fine.
The second result set, which is the one with the COMPUTE clause, returns 8
rows and the third resultset with one column named SUM.

The problem is that the SqlDataReader contains zero rows for both the second
and third results. They both report false for myReader.HasRows.

When I remove the COMPUTE clause in the stored procedure, the myReader shows
as having rows for the second result.

Is this a known problem?

 

[David Browne]

I'm working with a SqlDataReader returned by a SqlCommand.ExecuteReader()
that calls a SQL Server 2000 stored procedure that produces multiple
result
sets. One of the SELECT statements in the procedure has a COMPUTE clause.

The stored procedure, when executed within SQL Query Analyzer works fine.
The second result set, which is the one with the COMPUTE clause, returns 8
rows and the third resultset with one column named SUM.

The problem is that the SqlDataReader contains zero rows for both the
second
and third results. They both report false for myReader.HasRows.

When I remove the COMPUTE clause in the stored procedure, the myReader
shows
as having rows for the second result.

Is this a known problem?

Yes COMPUTE clause is not supported.

David

 

[David Browne]

Yes COMPUTE clause is not supported.

oops forgot the link:

 

[David Browne]

Yes COMPUTE clause is not supported.

The link
http://support.microsoft.com/kb/311540
David