In this stored procedure, I inserted some data from a few tables into a temporary table. The stored procedure returned the result sets by selecting from the temporary table. <BR>This works fine for JSP and did managed to get back the results. However when I tried to do the same for ASP, the error I got was that the object was closed. Any way to go around ?<BR>Currently I have changed the table to a permanent table and actually call two stored procedures to return the results.<BR>Pls help. Thanks.