Click here to Skip to main content
14,162,554 members
Rate this:
Please Sign up or sign in to vote.
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

What I have tried:

declare mytext varchar (500)
mytext = select name from linked server ip and database
insert into mytable ( mytextcolumn)
values (@mytext)
Updated 19-Feb-19 4:02am
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

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

sameralkhalili 20-Feb-19 15:55pm

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190518.1 | Last Updated 19 Feb 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100