I have a stored procedure in MSSQL 7 populate a local temporary table (#ttemp). The SP ends with SELECT * FROM #ttemp.
How can I get this selected data into VB6? If I execute the SP from VB no recordset is kept, I guess because the temporary table is dropped.

Anybody have a solution to how I can get this data from the SP into VB?

TIA
ChrisMan