duplication problem [modified]
-
Hi , In my table tbldataOrg i ve data like this pk slno name addr Date 1 1 see this 5/29/2010 1 1 see this 5/29/2010 1 1 see this 5/29/2010 2 2 Hi Us 5/30/2010 3 3 Hi Us 5/28/2010 I just want only 1 orginal data in tblDataOrg and insert other (in this case Pk 2 & 3, data entered from date 5/29/2010, not before that date is needed ) in new table tbldataDup and remove the duplicated data from tblDataOrg in MS SQl. Any Idea? Known is a drop, unknown is an ocean -- Modified Thursday, June 10, 2010 11:59 PM
-
Hi , In my table tbldataOrg i ve data like this pk slno name addr Date 1 1 see this 5/29/2010 1 1 see this 5/29/2010 1 1 see this 5/29/2010 2 2 Hi Us 5/30/2010 3 3 Hi Us 5/28/2010 I just want only 1 orginal data in tblDataOrg and insert other (in this case Pk 2 & 3, data entered from date 5/29/2010, not before that date is needed ) in new table tbldataDup and remove the duplicated data from tblDataOrg in MS SQl. Any Idea? Known is a drop, unknown is an ocean -- Modified Thursday, June 10, 2010 11:59 PM
Select distinct * into newtablename
This will put distinct records into a new table, you then need to deal with your problem. I suggest you engage a consultant to design your data structure for you or get a book on database and data design and start learning.
Never underestimate the power of human stupidity RAH