SELECT INTO is slow, horrendously slow on retrieving large recordsets.

Creating the table first, then doing and INSERT INTO is much faster, plus you have greater control over the table structure.

I think SELECT INTO trys to retrieve all data before creating the table and as the data doesn't have anywhere to go until the table is created it simply eats memory.  I could be wrong here.