You can't use create table to create the #tmp tables.  You have to let
the select...into... do the creation.