I have a number of duplicate email addresses in my SQL Server dbase (OK, OK now its a unique field).<BR><BR>Any idea of some SQL to get them out?
The link at the top of this page. <BR><BR>It's answered in one of the "database" sections. <BR><BR>
Use "select distinct EmailID from EamilTable"<BR><BR>Now u will get all unique IDs.<BR>I mean u can put in another table or u can store separately.
As Shaneh suggested, see the faq,<BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=186