• Jeff is correct about the table variables.

    The rerason why temp tables perform better for larger datasets is not so much parallelism but the fact that temp tables can use statistics.

    Also it would have been nice to mention the option of creating an index on a temp table. If you have really big datasets it can make quite a difference if you create an index on your temp table.

    [font="Verdana"]Markus Bohse[/font]