asked on 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 ?
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 ?
Microsoft SQL Server
Last Comment
Vitor Montalvão
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
Please share your current code. It will help us to point you the necessary things to do to solve your issue.
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