Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 30-06-2009
Member
 
Join Date: Feb 2009
Posts: 68
Need script to identify duplicate rows

hi,

There are hundreds of records in my document which I have stored in a tabular form. I want to find the number of duplicate rows that exists in my long table and then remove them. Can anybody provide me the script to identify the duplicate rows from the table. How can I do this ?
Reply With Quote
  #2  
Old 30-06-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: Need script to identify duplicate rows

If you want to delete the duplicate rows from the SQL table, follow the microsoft link below. This article provides all the necessary methods to identify and delete duplicate records from the SQL table.

http://support.microsoft.com/kb/139444
Reply With Quote
  #3  
Old 30-06-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: Need script to identify duplicate rows

Go through the following threads -

Delete duplicate rows using Macros

Delete duplicate tuples from a table in SQL Server

How to Remove Duplicate Entries from Table ?
Reply With Quote
  #4  
Old 30-06-2009
Member
 
Join Date: Jun 2009
Posts: 1
Re: Need script to identify duplicate rows

This is Renu. I want the following books
1)Puzzles to puzzle you - Shakuntala Devi
2)More puzzles - Shakuntala devi
3)Brain Teasers - George Summers
4)aptitude - R. S. Agarwal

hey guyz, if u have these books, dont forget to post ........
Reply With Quote
  #5  
Old 30-06-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: Need script to identify duplicate rows

Here you go for the first one Have it from the following attachment :
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need script to identify duplicate rows"
Thread Thread Starter Forum Replies Last Post
Delete duplicate rows using Macros Dyumani Windows Software 5 12-10-2011 11:30 AM
How to combine data in duplicate rows in MS excel Virginia Windows Software 7 10-07-2011 11:13 AM
Replace Duplicate Rows ajk79 Windows Software 1 20-07-2010 11:01 AM
Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003 awkwardsmile Software Development 2 09-07-2009 08:57 AM
How to identify Duplicate Files with Primitive Duplicate Finder Spykar Tips & Tweaks 1 25-03-2009 05:29 PM


All times are GMT +5.5. The time now is 08:17 AM.