Hi Everyone, I have a DB with about 500,000 records in it. This DB is from a sales lead form that is on our website. Occasionally we have customers submit the form twice or even more than that. I want to only display one of these leads to our sales dept if there is a duplicate, or I want to delete all the duplicates in there. I have tried several things but haevn't had as much success as I would like, I was using a query that would select just the top 1 id if there were duplicates which worked but it slowed down the query dramatically. I'm using CF to display my data and at times I would get an error that the process was deadlocked. Can someone give me some ideas on the best way to either display only one record if there are duplicates that won't cut performance time down or how I can delete all but one of the duplicates?
Thank You, Ben Densmore ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
