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!