This blog shows how to use insert query with stored procedure result. Using the result set of stored procedure the insert query inserts the data to the table
Syntax:
INSERT into table
( Column_list )
Exec Storedprocedurename
Example:
Insert into emptable
(Empname, Empid)
Exec usp_getempdetails
Note: stored procedure should return the same columns