Post reply

Query Analyzer Message Window

  • October 3, 2004 at 5:25 am

    #63441

    I am running batches of filters in QA on sql2k which manipulate small database of .25Meg rows. As each filter is actioned I see how many rows were affected, however I would like to add a batch identifier[name or number] in the sproc so that I can easily see which row count applies to which filter more easily.

    Any suggestions would be VERY welcome.

  • October 3, 2004 at 5:57 am

    #525130

    You could try one of these methods after each filter in the batch, and see if that's what you're looking for:

    select @@rowcount as 'Filter-name'

    or

    select rowcount_big() as 'Filter-name'

  • October 4, 2004 at 12:50 am

    #525148

    Thanks. I didn't realise I could give an alias to a global variable(?)

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

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