Gavin Draper's Blog

Father, Developer, Tech Geek, Extreme Sports Fanatic

@gavdraper | +gavdraper | github | StackOverflow Careers
 

Inserting A Stored Procedures Results In To A Table

Just a quick post to cover somthing that I've seen cropping up a lost recently. Thats copying the results of a stored procedure in to a table.


The code below will call the stored procedure spGetRecords and copy its results into
the specified table.



CREATE TABLE #tmpBus  
(
   COL1 INT,
   COL2 INT   
)

INSERT INTO #tmpBus  
Exec SpGetRecords 'Params'  

 
comments powered by Disqus