If you are looking for elapsed time, and if you can insert diagnostic code stored proc, you can insert some code into the outer stored proc like below:DECLARE @start DATETIME = GETDATE();
EXEC YourInnerStoredProc;
DECLARE @elapsedMilliSeconds = DATEDIFF(ms,@start,GETDATE()) ;
PRINT @elapsedMilliSeconds;
Find Time taken by inner procedure
Posted - 10/12/2012 : 05:47:16
