If I was to perform this query, which would you expect to be faster in SQL Server 2008 with a table containing 100_000 records:
First version (with #temp table):
SELECT one
, two
, ...
, n
INTO #results
FROM table AS temp
SELECT convert(...one)
, convert(...two)
, convert(...)
...