>When I run the procedure I get:
>There is already an object named '#ASTRA_BOOK' in the database.
>When i type in DROP TABLE #ASTRA_BOOK I get:
>
>Cannot drop the table '#ASTRA_BOOK', because it does not exist in the system catalog.
You cannot have 'CREATE TABLE #ASTRA_BOOK' twice in the same stored procedure even if only one is conditionally executed.
--sb--