Can you be nmore specific on how do you want to work with data inside sproc?
>When I call a stored procedure from Visual FoxPro it returns every result set to the client
>CREATE PROCEDURE dbo.Teste
>AS
>BEGIN
> select * from agenda
> select * from pais
> select getdate()
> RETURN 1
>END
>It returns 3 result sets to the client. Is there a way to avoid this? I want to do the queries
>I want to work with the data inside the procedure but I don't want the result sets back.
>
>TIA
--sb--