Create a table with store procedure results

[LonnieJohnson]

Can this be done? I have a stored procedure that has a union query sql. I have it in a sproc because it runs much faster there. I would like to take the result set and create a table. Is that possible?

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[RiverGuy]

No, but you can do something like the following:

CREATE TABLE #SomeTable (
SomeColumn INT,
SomeColumn2 VARCHAR(30))

INSERT INTO #SomeTable EXEC SomeProc

 

[LonnieJohnson]

Thanks. I actually ended up putting the sql in a view and putting the make a table sql in a stored procedure using the view as the data source. it runs just as fast.

That way if I need to add or remove fields, then I only do it in one place.

Thanks again.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!