>I'm leaning towards Solution 1 simply because it avoids dealing with the temporary table.
>
>-Mike

Thanks Mike,
It seems that the temporary tables are quite fast as well (based on the executions plans I compared). However, I did not have a significant number of records to test it with (500,000 was my sample table).