Temp Table and SP Advise
Hi All,
I have a little scenario here, i am need of inserting some rows into a
temp table which will be returned by a procedure... Here is little
explanation
I am planning to make a proc A and a temp table in proc A.
I will be calling proc B from Proc A.
What i want is the data returned by Proc B should be inserted into Proc
A's Temp table.
Can any one suggest me on this...
A little help will be highly appreciated.
Thanx
Cheers!
.
Relevant Pages
- Re: Temp Table and SP Advise
... > I have a little scenario here, i am need of inserting some rows into a ... > temp table which will be returned by a procedure... ... > I am planning to make a proc A and a temp table in proc A. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(comp.databases.ms-sqlserver) - Ongoing Saga Dell PE1850 - FreeBSD 6.0 Release Freezups.
... Extensive memory and mainboard diagnostics have been run. ... Ambient Temp | 29 degrees C | ok ... ECC Uncorr Err | Not Readable | ns ... PROC Protocol | Not Readable | ns ...
(freebsd-questions) - Re: on exception in SPL
... The stored proc is executes fine first. ... that the table you drop is only a temp table. ... The System therefore regenerates the sysprocplan ... For the time the sysprocplan is regenerated (and in a transaction until ...
(comp.databases.informix) - Re: How to find query plan for a stored procedure using temporary tables
... with temp tables to hold intermediate results. ... Create temp tables at the start of the stored proc. ... number of recompiles (and at 2000+ lines, ... get an execution plan for each step, and also to try different versions ...
(comp.databases.ms-sqlserver) - Re: get some records and then call a stored proc once for each??
... I have an AssignRep Stored proc. ... I would suggest you use a cursor if you have to loop through a set ... > right kind of cursor (fast forward is usually acceptable for a temp table) ... >> exec foo 3 ...
(microsoft.public.sqlserver.programming) |
|
