Hi Hector. If I understand you correctly, it seems as if you need to add SET NOCOUNT ON at the top of the stored procedure....
>Good Day!
>
>I would like to know how to pass an entire table generated from a stored procedure which will not require the use of a global temporary table.
>
>I tried doing it with a normal temporary table but when I issue an INSERT, DELETE, or UPDATE statement succeedingly before a SELECT statement I get no results in VB though In SQL SERVER I can see the the result of the SELECT statement. I would like to eliminate the use of Global Temporary Tables for there will be a minumum of 100 users that will be connecting to the server.
>
>Thank you.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell