Call sp within another sp

Question

I have an sp named 'FolderSttructure'.It returns the following result -

FolderID

1 2 3 4

I have to call the above sp 'FolderSttructure' inside another sp named 'SearchFolder' and insert the result of first sp in to a temperory table.

Is it possible?

If yes how can we do that?

Answer 1

Yse, you can do it like this:

CREATE TABLE #ATempTable
(
FolderID INTEGER
)

INSERT #ATempTable
EXECUTE FolderSttructure
...