FYI - Insert From SP Example

USE ...

GO

ALTER PROC foobar
AS
SELECT clientID, Nm FROM client

GO

CREATE TABLE #foos (clientID INT, Nm VARCHAR (255))

GO

INSERT #foos (clientID, Nm)
EXEC foobar

SELECT * FROM #foos

-- DROP TABLE #foos