Ther has been a known issue with using SELECT INTO into temp tables with regular SQL and may apply here. Try Create Table for the temp table then use INSERT INTO and see what happens.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)