first time through select into a temp table.

then you can play with the temp table without having to go back to main
query.