RE: FAQ submission: multiple results for a single query

Just to answer that question briefly: 

sp_help sometable

will return multiple result sets, in the sense being discussed, I think.

> 
> I think this sentence is confusing two separate issues.  What 
> exactly is a
> SQL statement which returns "multiple active result sets"?  I 
> don't know of
> any single SQL statement that would do that.  I don't like 
> FAQ answers that
> strongly depend on a confused viewpoint for interpretation.
>