Don't display dynamic query in result
- by Tom Andrews
Hi all,
Is it possible to hide a dynamic query from the result sets provided from a Stored Procedure?
I am using the @@rowcount of the dynamic query to set a variable that is used to determine whether another query runs or not.
The other query is used by code that I cannot change - hence why I am changing the Stored Procedure. The dynamic query returns as the first result set from the Stored Procedure is now the result of the dynamic query which currently is "breaking" the calling code.
Thanks in advance