execute Stored Proc inside another Stored Proc

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi,

I have two Stored Procs, I want to execute the first Stored Proc inside the second Stored Proc and get the resultset.

Is this possible in SQL 2005?

Thank you.

Posted 22-May-13 19:23pm

akosidab

Add a Solution

3 solutions

Solution 1

YES Its possible.

SQL

CREATE PROCEDURE FIRSTPROC
AS
BEGIN
    SET NOCOUNT ON
        EXEC SECONDPROC
    SET NOCOUNT OFF
END

Posted 22-May-13 19:39pm

Arun Vasu

Comments

akosidab 23-May-13 1:43am

How will I be able to get the result set of the secondproc?

Arun Vasu 23-May-13 3:20am

while you running firstProc you will get the result.

if you want that secondproc result use table variable and insert the result set into that. after that you can manipulate that.

CREATE PROCEDURE FIRSTPROC
AS
BEGIN
SET NOCOUNT ON
DECLARE @TABLE TABLE(COL1 INT, COL2 NVARCHAR(10))

INSERT INTO @TABLE
EXEC SECONDPROC

SELECT * FROM @TABLE
SET NOCOUNT OFF
END

_Amy 23-May-13 1:49am

+5!

Solution 2

Hi,

Try this ,

http://www.mssqltips.com/sqlservertutorial/163/returning-stored-procedure-parameter-values-to-a-calling-stored-procedure/[^]

Posted 22-May-13 19:47pm

Rockstar_

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

akosidab · Accepted Answer · 2013-05-22T20:16:00

Solution 3

Thanks to all your solution but it doesnt work.

I found a good solution:

SQL

insert into #table_temp
    exec [ap_StoreProc] @Param1;

Posted 22-May-13 20:16pm

akosidab