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.