如何在另一个内部使用存储过程的结果？

I have a stored procedure that I want to call from within another, and then loop through the results. Sort of like using a cursor with a stored procedure rather than a SQL select statement. I can't quite figure out how to do it.I have a stored procedure that I want to call f