-- SP_1
select .... -- a really complex query
return @@rowcount


-- SP_1Count
declare @iRows int
execute @iRows = SP_1
select @iRows as NumberOfItems

When SP1_Count is called from anywhere (QueryAnalyzer, VFP, ADO) there are two recordsets returned. I'd really like to only have the select @iRows result come back to the client. So how can I get SP_1Count to swallow up the recordset produced by SP_1?