Thread: How to copy distinct records from one table to another using SQL 2005
View Single Post
•
•
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: How to copy distinct records from one table to another using SQL 2005

 
0
  #3
Oct 24th, 2007
Use differential Backup...
or you can use insert select
like
MS SQL Syntax (Toggle Plain Text) 
  1. INSERT INTO table1 VALUES (SELECT DISTINCT a,b,c.. FROM table2)
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote