Wednesday, February 13, 2019

sql - Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]?



Select all data from BusinessLine into tmpBusLine works fine.



select *

into tmpBusLine
from BusinessLine


I am trying the same, but using a stored procedure that returns data, is not quite the same.



select *
into tmpBusLine
from
exec getBusinessLineHistory '16 Mar 2009'



Output message:




Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword
'exec'.





I have read several examples of creating a temporary table with the same structure as the output stored procedure, which works fine, but it would be nice to not supply any columns.

No comments:

Post a Comment

plot explanation - Why did Peaches' mom hang on the tree? - Movies & TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...