Calling One Stored procedure From Another Stored Procedure

Calling One Stored procedure From Another Stored Procedure

I.Create Stored Procedure to display employee details 

  

II.Create another Stored Procedure to call First Stored Procedure 

III.Execute the Second Stored Procedure 

Resultant Set:

Hope you understand the simple concept of calling one in another stored procedure 

Do have any query regarding my code you can comment below !!!