MS SQL and stored Procs

[eluser]btwong[/eluser]
I am calling a stored procedure from a Ms SQL database, but i am getting nothing returned.

Looking at the stored procedure, i can see that it gets all the required data, and puts it in a #Temp table. Then on the second last line it does a "select * from #temp".

The last line then does a "drop table #Temp".

How can i use php/codeigniter to get all the records/data from the "Select * from #Temp" query before the #Temp table is dropped?

thanks