<p>I would like to execute a stored procedure within a stored procedure, e.g. </p>

<pre><code>EXEC SP1

BEGIN

EXEC SP2
END
</code></pre>

<p>But I only want <code>SP1</code> to finish after <code>SP2</code> has finished running so I need to find a way for <code>SP1</code> to wait for <code>SP2</code> to finish before <code>SP1</code> ends.</p>

<p><code>SP2</code> is being executed as part of <code>SP1</code> so I have something like:</p>

<pre><code>CREATE PROCEDURE SP1
AS
BEGIN

EXECUTE SP2

END
</code></pre>

Thats how it works stored procedures run in order, you don't need begin just something like
```
```
exec dbo.sp1
exec dbo.sp2
```
```