First off, thanks for taking the time to help. And thanks for
mentioning that particular SQL "feature".
I've tried both ideas, together and separately. I even tried
I do not have the rights to create stored SQL procedures. So I am
This difference makes me wonder if what I am trying to do (use more
Are there any other ideas out there of how to get what I want?
On Oct 27, 5:09 pm, Michael Kleehammer <mkleeham...@gmail.com> wrote:
> Summary: Add "SET NOCOUNT ON" to the top of your stored procedure.
> SQL Server has a very annoying habit of returning *everything* as part of
> If you add SET NOCOUNT ON, the non-select results will not be returned.
> You can also use Cursor.nextset() to "step over" non-select results.
> I may consider automatically doing this unless a flag is used to turn it
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.