------------------------------------------------------------------
use master
IF OBJECTPROPERTY (OBJECT_ID('TblDelSupplier'),'ISTABLE') = 1 DROP TABLE TblDelSupplier
IF OBJECTPROPERTY (OBJECT_ID('TblDelCustomer'),'ISTABLE') = 1 DROP TABLE TblDelCustomer

CREATE TABLE TblDelSupplier (SuppCode Varchar(255))
CREATE TABLE TblDelCustomer (SuppCode Varchar(255))
------------------------------------------------------------------
INSERT INTO TblDelSupplier 
select VouSuppCode COLLATE DATABASE_DEFAULT from t201920.dbo.purchase_detail UNION select VouSuppCode from t202021.dbo.purchase_detail UNION select VouSuppCode from T202122.dbo.purchase_detail UNION select VouSuppCode from T202223.dbo.purchase_detail 
UNION select VouSuppCode COLLATE DATABASE_DEFAULT from t201920.dbo.opening_purchase_detail UNION select VouSuppCode from t202021.dbo.opening_purchase_detail UNION select VouSuppCode from T202122.dbo.opening_purchase_detail UNION select VouSuppCode from T202223.dbo.opening_purchase_detail 
UNION select RecSuppCode from t201920.dbo.RECEIVED_DETAIL UNION select RecSuppCode from t202021.dbo.RECEIVED_DETAIL UNION select RecSuppCode from T202122.dbo.RECEIVED_DETAIL UNION select RecSuppCode from T202223.dbo.RECEIVED_DETAIL
UNION select RtnSuppCode from t201920.dbo.RETURN_GOODS_DETAIL UNION select RtnSuppCode from t202021.dbo.RETURN_GOODS_DETAIL UNION select RtnSuppCode from T202122.dbo.RETURN_GOODS_DETAIL UNION select RtnSuppCode from T202223.dbo.RETURN_GOODS_DETAIL

INSERT INTO TblDelCustomer
select VouCustCode COLLATE DATABASE_DEFAULT from t201920.dbo.purchase_detail UNION select VouCustCode from t202021.dbo.purchase_detail UNION select VouCustCode from T202122.dbo.purchase_detail UNION select VouCustCode from T202223.dbo.purchase_detail 
UNION select VouCustCode COLLATE DATABASE_DEFAULT from t201920.dbo.opening_purchase_detail UNION select VouCustCode from t202021.dbo.opening_purchase_detail UNION select VouCustCode from T202122.dbo.opening_purchase_detail UNION select VouCustCode from T202223.dbo.opening_purchase_detail 
UNION select RecCustCode from t201920.dbo.RECEIVED_DETAIL UNION select RecCustCode from t202021.dbo.RECEIVED_DETAIL UNION select RecCustCode from T202122.dbo.RECEIVED_DETAIL UNION select RecCustCode from T202223.dbo.RECEIVED_DETAIL
UNION select RtnCustCode from t201920.dbo.RETURN_GOODS_DETAIL UNION select RtnCustCode from t202021.dbo.RETURN_GOODS_DETAIL UNION select RtnCustCode from T202122.dbo.RETURN_GOODS_DETAIL UNION select RtnCustCode from T202223.dbo.RETURN_GOODS_DETAIL
------------------------------------------------------------------
DELETE FROM T201920.dbo.CUSTOMER_MASTER WHERE CustCode COLLATE DATABASE_DEFAULT NOT IN (SELECT CustCode FROM master.dbo.TblDelCustomer)
DELETE FROM T202021.dbo.CUSTOMER_MASTER WHERE CustCode COLLATE DATABASE_DEFAULT NOT IN (SELECT CustCode FROM master.dbo.TblDelCustomer)
DELETE FROM T202122.dbo.CUSTOMER_MASTER WHERE CustCode COLLATE DATABASE_DEFAULT NOT IN (SELECT CustCode FROM master.dbo.TblDelCustomer)
DELETE FROM T202223.dbo.CUSTOMER_MASTER WHERE CustCode COLLATE DATABASE_DEFAULT NOT IN (SELECT CustCode FROM master.dbo.TblDelCustomer)
------------------------------------------------------------------
DELETE FROM T201920.DBO.SUPPLIER_MASTER WHERE SuppCode COLLATE DATABASE_DEFAULT NOT IN (SELECT SuppCode FROM master.dbo.TblDelSupplier)
DELETE FROM T202021.DBO.SUPPLIER_MASTER WHERE SuppCode COLLATE DATABASE_DEFAULT NOT IN (SELECT SuppCode FROM master.dbo.TblDelSupplier)
DELETE FROM T202122.DBO.SUPPLIER_MASTER WHERE SuppCode COLLATE DATABASE_DEFAULT NOT IN (SELECT SuppCode FROM master.dbo.TblDelSupplier)
DELETE FROM T202223.DBO.SUPPLIER_MASTER WHERE SuppCode COLLATE DATABASE_DEFAULT NOT IN (SELECT SuppCode FROM master.dbo.TblDelSupplier)
------------------------------------------------------------------
DROP TABLE master.dbo.TblDelSupplier 
DROP TABLE master.dbo.TblDelCustomer