I need to insert some fields into a temp table then run a SELECT statement 
to get the final records for a report and sometimes for a
recordset used in an ASP page. The INSERT followed by a SELECT FROM works 
fine in the SQL2000 query analyser but in an Access stored proc
it only does the INSERT but not the SELECT and so reports that the
stored procedure executed without errors, but no records were returned.

Alan