Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Delete Duplicates

Author  Topic 

Gideon
Starting Member

15 Posts

Posted - 2002-06-06 : 19:52:00
Hi,

I'm trying to delete duplicates from a result set. I run a query then have written a macro in excel to delete duplicates based on several of the columns in the query, but not all columns...can this be done in the query before I hit excel?

cheers

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-06-06 : 20:01:31
Hi

Check the FAQ, you will find the answer there

Damian
Go to Top of Page

Gideon
Starting Member

15 Posts

Posted - 2002-06-06 : 20:07:21
Can you be more specific please..

Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-06-06 : 20:15:28
www.sqlteam.com/faq.asp

Damian
Go to Top of Page
   

- Advertisement -