Use data from stored procedure for insert or update a table

Question

I have a stored procedure for query some data. I want get this data and put into table or update the table with these data. how can i get this? I have tried many methods and all fail. somebody can help me please??

Andriy M · Accepted Answer · 2011-08-17 09:05:16Z

1

You can run the Stored Procedure using OPENQUERY if it doesn't use parameters, or if you can hardcode the parameters, e.g.

update othertable
  set ....
from openquery([SQLSERVER], 'exec ABC') X
join othertable ....

(Replace SQLSERVER with the name of the server/instance.)

Or you can put the data from the proc into a temp table then join to it, e.g.

insert #tmptablename
exec ABC 1,2,3

(where you first create #tmptablename with the exact columns expected from the resultset from proc "ABC")

edited Aug 17, 2011 at 9:05

Andriy M

78k18 gold badges100 silver badges157 bronze badges

answered Aug 8, 2011 at 23:22

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use data from stored procedure for insert or update a table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related