Home Forums SQL Server 2008 SQL Server 2008 - General Copying Table1 to Table2 RE: Copying Table1 to Table2
Suresh B.
SSC-Insane
Points: 22986
More actions
June 24, 2010 at 3:18 am
#1184387
monzulu (6/24/2010) i want to copy the contents of table1 to table2 and "prune" table1 with only 1 occurence of each place......thanks for any advice and suggestions.
monzulu (6/24/2010)
.....
thanks for any advice and suggestions.
SELECT ...UNION... also can be used to achieve this.