Declare @T Table(Column)

INSERT INTO @T(COLUMN)
EXEC yourStoredprocedure

Select * From @T

SELECT @myVariable=myColum FROM myTable