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