------HASTE MASTER

USE T27K002

IF OBJECTPROPERTY (OBJECT_ID('TblHaste'),'ISTABLE') = 1 DROP TABLE TblHaste
CREATE TABLE TblHaste (TCode Varchar(255))
INSERT INTO TblHaste SELECT Haste FROM CHALLAN_DETAIL UNION SELECT Haste FROM BILL_DETAIL UNION SELECT Haste FROM RECEIVED_RETURN_GOODS_DETAIL UNION SELECT Haste FROM ORDER_BILL_DETAIL UNION SELECT Haste FROM FINISHED_PURCHASE_ORDER_FORM UNION SELECT Haste FROM OPENING_FINISHED_PURCHASE_ORDER_FORM UNION SELECT Haste FROM GREY_PURCHASE UNION SELECT Haste FROM FINISHED_PURCHASE UNION SELECT Haste FROM OPENING_GREY_PURCHASE UNION SELECT Haste FROM OPENING_FINISHED_PURCHASE UNION SELECT Haste FROM OPENING_ORDER_BILL_DETAIL UNION SELECT Haste FROM BARCODE_STOCK
DELETE FROM HASTE_MASTER WHERE (Haste NOT IN (SELECT TCode FROM TblHaste))
DELETE FROM common.dbo.HASTE_MASTER WHERE (Haste NOT IN (SELECT TCode FROM TblHaste))


-------SCAN COMMON MASTER AFTER RUN THE QUERY