Post reply

The maximum number of result sets that can be displayed in the results grid

  • June 23, 2009 at 3:03 pm

    #135387

    When running a script, I got the following message:

    The query has exceeded the maximum number of result sets that can be

    displayed in the results grid. Only the first 100 result sets are

    displayed in the grid.

    Does anyone know how to increase the maximum number if possible.

    Many thanks in advance.

  • June 23, 2009 at 11:12 pm

    #1014425

    It sounds like you're using a cursor or while loop. What is it that you're doing that requires one?

    As a side bar, you can get around the limitations of the grid by switching to the text mode with column alignment. Still, there's that cursor thing I'm worried about.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply