I knew one (the creation of the primary keys), but didn't know the other. Thank-you for sharing.
However, it would be interesting to see an actual field use of using a INSERT INTO...SELECT... using the same table as destination and source.
commented on Aug 23 2011 9:03AM