Hi, in my app, I'm using stored procedures in SQL Server. Is it possible to have 1 stored procedure return results from another? I want to pass an employee name to the main sp, have the main sp call another sp (that parses the name and returns the result), and then have the main sp update the employee's record.

Thanks.