Hi new user here. But don't hold that against me.

I need a little help. I am using VB5 attaching to SQL Server 6.5, I have created a stored procedure which outputs to a temp table. what I want to do is....

Execute the stored procedure from within my vb code but before the temp table is dropped populate a recordset so that i can use the information returned by the Stored Proc.

Any Help would be greatly appreciated.

Thanks
Inferno!