[dba-SQLServer]Stored procedure question

Then it's the way your running part of your process, one way to go around
this is if your looking for result sets is to use the Exists command so you
could check

IF EXISTS(SELECT Fields FROM Table)
    BEGIN
        --Do stuff here for True
    END
ELSE
    BEGIN
        --Do Stuff here for False
    END




-Francisco
http://rcm.netfirms.com/

On Monday, June 16, 2003 8:59 AM [GMT -8],
Michael Brösdorf <michael.broesdorf at web.de> wrote:

: Hi David,
:
: if NOCOUNT is set to ON the number of rows affected by each SQL
: Select is not returned. However, the rows are still displayed in
: query analyzer.
:
: I want to create a tool for the dba that checkes the consistency of
: several data tables. I created a table containing SQL Statements is
: processed by the sp and results are written to a log table. when the
: sp is finished, the result rows from the log table should be
: displayed in the result pane of the Query Analyzer.
:
: The number of tables to be checked is about 10 with several
: conditions for each table. It works fine so far except that the
: result pane contains 31 result sets, which is quite ugly...
:
: Michael
:
: -----Ursprüngliche Nachricht-----
: Von: dmcafee at pacbell.net [mailto:dmcafee at pacbell.net]
: Gesendet: Montag, 16. Juni 2003 17:45
: An: michael.broesdorf at web.de
: Betreff: RE: [dba-SQLServer]Stored procedure question
:
:
: look at SET NOCOUNT = ON (and off) in BOL, I think that's what you're
: looking for.
:
: HTH
:
: David
:
: -----Original Message-----
: From: dba-sqlserver-bounces at databaseadvisors.com
: [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
: Francisco Tapia
: Sent: Monday, June 16, 2003 8:29 AM
: To: dba-sqlserver at databaseadvisors.com
: Subject: Re: [dba-SQLServer]Stored procedure question
:
:
: hmm, It might be helpful to see what you are doing, could you post
: the code?
:
: -Francisco
: http://rcm.netfirms.com/
:
: On Monday, June 16, 2003 7:55 AM [GMT -8],
: Michael Brosdorf <michael.broesdorf at web.de> wrote:
:
:: Dear group,
::
:: I have a stored proc that includes a whole bunch of SELECT
:: statements. When the sproc is executed used Query Analyzer, the
:: result sets of all those SELECT's is displayed. But I want only the
:: result set of the last SELECT to be displayed.
::
:: Is that possible?
::
::
:: TIA,
::
::
:: Michael
::
:: _______________________________________________
:: dba-SQLServer mailing list
:: dba-SQLServer at databaseadvisors.com
:: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
:: http://www.databaseadvisors.com
:
:
: _______________________________________________
: dba-SQLServer mailing list
: dba-SQLServer at databaseadvisors.com
: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
: http://www.databaseadvisors.com
:
: _______________________________________________
: dba-SQLServer mailing list
: dba-SQLServer at databaseadvisors.com
: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
: http://www.databaseadvisors.com