>
>
>select ....
>return @@rowcount
>
>
>
>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?
Here another approach, suggested by a member of another forum (I even didn't thought about this :o):
SELECT count(*)
FROM OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off exec YourDB.dbo.SP_1)
AS tbl
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.