>In addition to Bruce 3rd is to select into a temp table.
I left that one out purposely, Cetin, I don't like recommending that technique to get anyone started using old techniques :)
>And another could be runtime created view that's dropped when done.
But this is certainly a good additional idea to consider.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.