[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