This is probably a really simple problem, but here goes:

I have a stored procedure. Within this stored procedure I am executing
another stored procedure for the purpose of retrieving data from 2 output
variables. The trouble is, it also returns a resultset which I would like to
ignore as I wish to return one from the parent SP.

is there a way to exec a stored procedure and ignore its result set?

Thanks
Lee

Sorry, I posted to the wrong forum by mistake.

I have posted my question to microsoft.public.sqlserver.programming

please reply there.

Lee.

"Lee Swanson" <lee (AT) lessspam (DOT) ibc.com.au> wrote