take the stored procedure and make it a function. Functions can be used in the FROM part of a query...