• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 44
  • Last Modified:

stored procedure calling others stored procedure

I have a stored procedure wich is calling a multiple of other stored procedure.

the problem is that I only want to get the result of this procedure and not the results of the other one (wich is a select)

SET NOCOUNT ON do not work in this case...

any help ?
  • 2
1 Solution
Brian CroweDatabase AdministratorCommented:
You can dump the stored procedure results into a temp table or table variable.  This will prevent them from becoming part of the external procedures resultsets
bruno_boccaraAuthor Commented:
that's what I found in other forum.
I tried to make an insert into Exec Proc and I got an error telling that it was not possible to do it when procedures are called into a procedure
Brian CroweDatabase AdministratorCommented:
I know for a fact that it can be done.  If you can share your code and the error you are receiving we can try and get to the bottom of it.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Please share your current code. It will help us to point you the necessary things to do to solve your issue.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now