Jeff,
since no one helped you it looks like i'm "coolest" SQL programmer on this list.
:-)))))))))))
select * from tblMyTable as tblOuterTable
where exists
(
select count(*) from tblMyTable as tblInnerTable
where tblInnerTable.email = tblOuterTable.email
having count(*) > 1
)
Wednesday, September 24, 2003, 9:11:26 PM, you wrote:
Jeff> Pseudocode:
Jeff> "delete every entry in MyTable where MyTable.Email is duplicated"
Jeff> Trying to take a list with possible duplicate entries and remove all the
Jeff> duplicates except one so that all are left is a single instance of an email
Jeff> address, regardless of capitalization
Jeff> Table: EmailAddresses
Jeff> Column: Email
Jeff> That's all. It sounds deceptively easy, doesn't it? Lol...
Jeff>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1668
Archives: http://www.houseoffusion.com/lists.cfm?link=t:6
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
ColdFusion MX 6.1, now 2.5 times faster.
http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
