Deleting multiple customers

We can write you a SQL that will do it. Cost to you is $85.00 let me know if you want it. snipped-for-privacy@sc.rr.com MS Partner

$85.00 to write: DELETE Customer WHERE TotalSales = 0 That works out to be $2.74 per character.

MAKE SURE YOU BACKUP YOUR DATABASE BEFORE RUNNING ANY QUERY!!!!

Rob

Wow :)

I know you can afford to buy a 85 dollar sql :)

Normally,people who have more experience than me will tell you to "better to delete the customer in MRMS itself rather than doing it in fast pace deletion to avoid unwanted orphaned records". Yeah, it is true but still a stubborn as I am, wil give you an option but you have to bear the adverse effect. Let them give thier opinion on this matter :) But seriously, back up your data first and run this query if you know sql. If not asked more expert opinion

--Here I am checking if the customer made any purchases through transaction table if no purchases made then delete them from customer table.

---SQL command starts here delete from customer where [id] not in (select customerid from [transaction])

---end here---

Good luck

"lax guy" wrote:

these r the tables that might have orphan records to the deleted customers:-

AccountReceivable Journal Order Payment ShipTo Transaction TransactionHold

please make sure u check them as well, most of them shouldn't have related records if there's nothing in Transaction table, but just wanted to make the picture clear for u

Nashat

I purchased a company who used RMS as a contact data base in that they added customers who never made purchases. Thus I need to remove around 2500 customers who really aren?t customers. Can any one tell me what the best way is to remove these entries?