How to insert results of a stored procedure into a table

Transact-SQL
1

The execution of the Stored Procedure below results in the following output:
image

The above is just an output. It is not created in a view or a table.

I would like the output to be stored in a table or view.

I know when you see the Stored Procedure there will be lots of questions as to why I want to do this when I can just reference the TVF directly? Please trust me it just is easier for me to do it this way if possible.

The Stored Procedure is as follows:

CREATE PROC outbound.usp_Terminals(@AsOfDate date)

AS

SELECT  
	airport_code,
	airport_name,
	airport_city,
	airport_state
FROM 
	dbo.fnGetAirports(@AsOfDate)

GO

I was thinking the solution would be something like

select ... into... from...

2 

DECLARE @date date
SET @date = ...

INSERT INTO #prebuilt_table
EXEC dbo.outbound.usp_Terminals @date
3

Hi ScottPletcher,

Thank you very much for reaching.
Please forgive the silly question, but where you mention #prebuilt_table, are you saying that I need to have already created a table to be inserted into?

4

Hi ScottPletcher,

I tried you suggestion but it didn't work

5

What does "didn't work" mean? What code did you run? Was there an error? Was there no error, but the results weren't what you expected?

6

Hi SqlHippo

I rant the following:

CREATE PROC outbound.usp_Terminals(@AsOfDate date)

AS

DECLARE @date date
SET @date = ...


SELECT  
	airport_code,
	airport_name,
	airport_city,
	airport_state
INSERT INTO #prebuilt_table
EXEC dbo.outbound.usp_Terminals @date
FROM 
	dbo.fnGetAirports(@AsOfDate)

GO
7

This actually worked.
Thank you very much ScottPletcher