|
Home > Archive > Microsoft SQL Server forum > May 2005 > Multiple SQL statements in a stored procedure
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Multiple SQL statements in a stored procedure
|
|
| Peter Neumaier 2005-05-25, 8:24 pm |
| Hi!
I got 2 stored procedure, proc1 executes proc2,
proc2 does some updates and inserts on different tables ...
proc1:
ALTER PROCEDURE
AS
execute proc2
SELECT * FROM tblFoo
____________________
__
my problem is, that when executing proc1, I receive the message:
"THE SP executed successfully, but did not return records!"
But I need the resultset from "SELECT * FROM tblFoo" that is executed
at the end of proc1.
I'm not sure, but I think that I solved a similira problem with "set
nocount on", I put it into both SP, but it's still the same ... no
resultset ...
How can I display "SELECT * FROM tblFoo" within a SP, where SQL
statements are executed before?!
Thank you!
| |
| Robin Tucker 2005-05-26, 9:23 am |
| Err, stupid question but did you check that tblFoo actually has records in
it?
"Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
news:1117053332.823938.254990@g14g2000cwa.googlegroups.com...
> Hi!
>
> I got 2 stored procedure, proc1 executes proc2,
> proc2 does some updates and inserts on different tables ...
>
>
> proc1:
>
> ALTER PROCEDURE
> AS
> execute proc2
>
> SELECT * FROM tblFoo
> ____________________
__
> my problem is, that when executing proc1, I receive the message:
>
> "THE SP executed successfully, but did not return records!"
>
> But I need the resultset from "SELECT * FROM tblFoo" that is executed
> at the end of proc1.
> I'm not sure, but I think that I solved a similira problem with "set
> nocount on", I put it into both SP, but it's still the same ... no
> resultset ...
>
> How can I display "SELECT * FROM tblFoo" within a SP, where SQL
> statements are executed before?!
>
> Thank you!
>
|
|
|
|
|