Doing a SELECT INTO using a Stored Proc as the data source I have a stored proc that returns a resultset.
I would like to deposit that resultset into a table. Kind of like a
"SELECT INTO", but using a stored proc.
If I could do this --
SELECT INTO MyTable FROM MyStoredProc
-- I'd be happy.
What are the alternatives? |