Video talks about
Creating stored procedures with output parameters
executing stored procedures with output parameters
stored procedures with output parameters
Creating stored procedures with input and output parameters
executing stored procedures with input and output parameters

Step by step SQL Training videos
SQL Tutorial

For more videos
   / @training2sqlmsbi