I'm calling a stored procedure from within a stored procedure and need to get the return value.
I'm calling EXEC CreateCompany @Company_Name, @EmployeeNo_ID, @Creator, @Created
within CreateCompany I do this to get the new ID...
How can I use this value in my original stored procedure?
Any help would be appreciated.