Hi salemcycle.
First of all, if you are planning to use any tSQL sentence against your RMS database, to delete Supplier records or anything else, please first of do it in TESTING environment!! Direct deleting can break your RMS database...
OK, now back to your problem. Knowing that Supplier "data" is stored not only in Supplier table, but also in tables as Item, PurchaseOrder and SupplierList, your tSQL script should have this included. From your question, I understand you have only "duplicated" the Suppliers, you haven't done anything with those suppliers after the import from QuickBooks. Meaning, you havent made PO against this Suppliers, nighter You have assigned Items to them, etc., etc.,... Can You confirm this, please?
Assuming that this is true, and there is notning associated to this "duplicated" suppliers, your tSQL query should be something like this:
DELETE FROM [Supplier]
WHERE [Supplier].[ID] NOT IN
(SELECT SupplierID FROM [SupplierList])
DELETE FROM [Supplier]
WHERE [Supplier].[ID] NOT IN
(SELECT SupplierID FROM [Item])
Now, before DELETING, I would run this 2 tSQL quieries, but in SELECT mode, just to confirm that the queries are working with the correct Supplier records:
SELECT * FROM [Supplier]
WHERE [Supplier].[ID] NOT IN
(SELECT SupplierID FROM [SupplierList])
SELECT * FROM [Supplier]
WHERE [Supplier].[ID] NOT IN
(SELECT SupplierID FROM [Item])
At then end, PLEASE HAVE IN MIND that this tSQL's are deleting not only the "duplicated" Suppliers, but all the Suppliers who don't have any Items assigned to them, "duplicated" with the import or not!
If You don't have much experiance with SQL, please contact your RMS Partner. Anything I can help, do not hesitate in writing to me...
BR, Antonijo
