There are two ways to this, you can get the list of stored procedures into a variable (object type) then process it in two ways :
1. Process...