Click here to Skip to main content
15,887,266 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hi all
my problem is when i call stored procedure it contain select and insert statements
i mean i call select statement and insert result into variable
then i try to insert the value of select into insert statemen in my table
by the way the select come from linked server... it take about 4 minutes to execute it self so when i used it in stored procedures it do nothing... i think s. p time is out and not continue.
please any ideas
thanks

What I have tried:

declare mytext varchar (500)
mytext = select name from linked server ip and database
.....
insert into mytable ( mytextcolumn)
values (@mytext)
Posted
Updated 19-Feb-19 4:02am
Comments
CHill60 19-Feb-19 10:16am    
That looks like a single select and insert - you haven't got that inside a cursor have you?

1 solution

 
Share this answer
 
Comments
sam9787 20-Feb-19 15:55pm    
great

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900