How can I iterate through a resultset from an sp in the same way that I
can go through a cursor/select's output?

I want to do all this within a (caller) sp. And so handle another sp's
resultset as if it was a server cursor.

Is this possible?

(Example - I want to go through the output of  "sp_who objname" to format
it better. Maybe in this example there are server tables/views I could use
in a cursor instead, but I'd like a general solution to the problem).

Gary