Posted by Robin Tucker on 05/26/05 17:27

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!
>

[Back to original message]