Honny (11/11/2013)
As you mentioned there is no Foreign Keys so truncate and load is better.1. If you drop the table again you have to create the table and load.
2. You have drop the Table if there is any changes in he table structure from previous load that time it is better way but in your case truncate and load is better.
I don't believe so. I believe that the SELECT/INTO solution that "SQL_Learning" proposed will do the trick and no modifications to the table will be required if the source-query ever changes.
--Jeff Moden
Change is inevitable... Change for the better is not.