Can I execute a stored procedure without getting a result?

[galore]

I am trying to do something like this inside a stored procedure:

EXEC searchEvent 'Exhibition'
IF @@ROWCOUNT > 0
BEGIN
SELECT 'EXHIBITION'
END

The problem is that searchEvent returns a record set. This way i got two record set. How can I do the test if searchEvent returns anything without displaying it?

Regards
Galore

 

[pgtek]

Hi
just use Cast(your field name) as ' '

 

[galore]

Hi pgtek!
I dont understand how this can help me.
Can you explain it further please?

Regards
Galore

 

[FoxyBOA]

Hi!
If you procedure searchEvent return single recordset you could declare temp table and store result into it.
DECLARE #t (...)
INSERT INTO #t(COLUMN NAMES) EXEC searchEvent '...'

But signifficatly easy from my point of view declare out parameter and return in from SP (such sollution also applicable for multiple recordset SPs).