Multiple SQL statements in a stored procedure

[Peter Neumaier]

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]

Re: Multiple SQL statements in a stored procedure

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.goo glegroups.com.. .[color=blue]
> 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!
>[/color]