• SELECT INTO will create a new temporary table with exactly the same columnnames and datatypes, while in the second case you first have to do a create tabel where you can define alternative columnnames and to a certain degree different datatypes.

    I don't think there's a big difference in performance.

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