-
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.
-
Set your database to "master" (in Enterprise Manager) and take a look at some of the system stored procedures, sp_help and sp_addgroup being some good examples of what you want to do...
