>Actually to another Stored Procedure. I am making a common stored procedure that other stored procedures can call and compare with or look up on. Far fetched idea? What I am trying to do is avoid repeatative blocks of commands.

You can but I doubt you would want to because it's kludgy. It requires you to create a temp. table with the structure of result set returned. See Re: Using result set Message #644072.