Using one stored procedure from another.

I went with the a temporary table, INSERT and EXEC as I didn't want to modify the existing stored procedures.

See How to Share Data Between Stored Procedures