Brandie Tarvin (10/2/2013)
I'm not sure I'm clear on this...Proc 0 is taking less time than Proc 1, right?
Nothing else happens in Proc 0 except that EXEC statement, right?
In which case this makes total sense to me because all Proc 0 does is send the call and then end execution. Proc 0 isn't using any of its resources after it sends the call and Proc 1 requires time to execute.
But if I'm misreading your post, please let me know.
That's it...
The start time in proc1 statement "EXEC proc0" and proc0 1st execution aren't the same.
That difference is the time SQL takes to "load" proc0 so it can be executed?
Pedro