⬅ Back Insert Company.txt
INSERT INTO TamCOMP.dbo.COUNTRY_MASTER SELECT DISTINCT * FROM T20G001.dbo.COUNTRY_MASTER
INSERT INTO TamCOMP.dbo.STATE_MASTER SELECT DISTINCT * FROM T20G001.dbo.STATE_MASTER
INSERT INTO TamCOMP.dbo.ITEM_ON_MASTER SELECT DISTINCT * FROM T20G001.dbo.ITEM_ON_MASTER
INSERT INTO TamCOMP.dbo.SERIES_MASTER SELECT DISTINCT * FROM T20G001.dbo.SERIES_MASTER
INSERT INTO TamCOMP.dbo.MARKET_MASTER SELECT DISTINCT * FROM T20G001.dbo.MARKET_MASTER
INSERT INTO TamCOMP.dbo.CITY_MASTER SELECT DISTINCT * FROM T20G001.dbo.CITY_MASTER
INSERT INTO TamCOMP.dbo.CATALOG_MASTER SELECT DISTINCT * FROM T20G001.dbo.CATALOG_MASTER
INSERT INTO TamCOMP.dbo.BANK_MASTER SELECT DISTINCT * FROM T20G001.dbo.BANK_MASTER
INSERT INTO TamCOMP.dbo.JOB_CHALLAN_MASTER SELECT DISTINCT * FROM T20G001.dbo.JOB_CHALLAN_MASTER
INSERT INTO TamCOMP.dbo.VOUCHER_TYPE_MASTER SELECT DISTINCT * FROM T20G001.dbo.VOUCHER_TYPE_MASTER
INSERT INTO TamCOMP.dbo.HASTE_MASTER SELECT DISTINCT * FROM T20G001.dbo.HASTE_MASTER
INSERT INTO TamCOMP.dbo.GENERAL_ITEM_MASTER SELECT DISTINCT * FROM T20G001.dbo.GENERAL_ITEM_MASTER
INSERT INTO TamCOMP.dbo.ITEM_CATEGORIES_MASTER SELECT DISTINCT * FROM T20G001.dbo.ITEM_CATEGORIES_MASTER
INSERT INTO TamCOMP.dbo.ITEM_QUALITY_MASTER SELECT DISTINCT * FROM T20G001.dbo.ITEM_QUALITY_MASTER
INSERT INTO TamCOMP.dbo.ACCOUNT_TYPES SELECT DISTINCT * FROM T20G001.dbo.ACCOUNT_TYPES
INSERT INTO TamCOMP.dbo.COMPANY_DETAIL SELECT DISTINCT * FROM T20G001.dbo.COMPANY_DETAIL
INSERT INTO TamCOMP.dbo.AGENT_MASTER SELECT DISTINCT * FROM T20G001.dbo.AGENT_MASTER
INSERT INTO TamCOMP.dbo.GROUP_MASTER SELECT DISTINCT * FROM T20G001.dbo.GROUP_MASTER
INSERT INTO TamCOMP.dbo.ACCOUNT_MASTER SELECT DISTINCT * FROM T20G001.dbo.ACCOUNT_MASTER
INSERT INTO TamCOMP.dbo.GREY_ITEM_MASTER SELECT DISTINCT * FROM T20G001.dbo.GREY_ITEM_MASTER
INSERT INTO TamCOMP.dbo.FINISHED_ITEM_MASTER SELECT DISTINCT * FROM T20G001.dbo.FINISHED_ITEM_MASTER
INSERT INTO TamCOMP.dbo.SCREEN_ITEM_MASTER SELECT DISTINCT * FROM T20G001.dbo.SCREEN_ITEM_MASTER
INSERT INTO TamCOMP.dbo.SUB_SCREEN_ITEM_MASTER SELECT DISTINCT * FROM T20G001.dbo.SUB_SCREEN_ITEM_MASTER
INSERT INTO TamCOMP.dbo.TRANSPORT_MASTER SELECT DISTINCT * FROM T20G001.dbo.TRANSPORT_MASTER
INSERT INTO TamCOMP.dbo.TDS_TYPE_MASTER SELECT DISTINCT * FROM T20G001.dbo.TDS_TYPE_MASTER
INSERT INTO TamCOMP.dbo.RANGE_DESCRIPTION_MASTER SELECT DISTINCT * FROM T20G001.dbo.RANGE_DESCRIPTION_MASTER
INSERT INTO TamCOMP.dbo.BILL_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BILL_DETAIL
INSERT INTO TamCOMP.dbo.BILL_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BILL_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.BILL_ITEM_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BILL_ITEM_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.BILL_ITEM_IF_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BILL_ITEM_IF_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.BILL_ITEM_GREY_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BILL_ITEM_GREY_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.BILL_ITEM_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BILL_ITEM_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.BILL_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BILL_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.READY_STOCK_WISE_SALE SELECT DISTINCT * FROM T20G001.dbo.READY_STOCK_WISE_SALE
INSERT INTO TamCOMP.dbo.LOT_WISE_SALE_STOCK SELECT DISTINCT * FROM T20G001.dbo.LOT_WISE_SALE_STOCK
INSERT INTO TamCOMP.dbo.CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.CHALLAN_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.CHALLAN_ITEM_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_ITEM_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.CHALLAN_ITEM_GREY_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_ITEM_GREY_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.FINISHED_PURCHASE SELECT DISTINCT * FROM T20G001.dbo.FINISHED_PURCHASE
INSERT INTO TamCOMP.dbo.FINISHED_PURCHASE_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.FINISHED_PURCHASE_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.FINISHED_PURCHASE_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.FINISHED_PURCHASE_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.GREY_PURCHASE SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_ITEM_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE_ITEM_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.PAYMENT_BANK_BOOK_DETAIL SELECT DISTINCT * FROM T20G001.dbo.PAYMENT_BANK_BOOK_DETAIL
INSERT INTO TamCOMP.dbo.PAYMENT_BANK_BOOK_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.PAYMENT_BANK_BOOK_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.PAYMENT_CASH_BOOK_DETAIL SELECT DISTINCT * FROM T20G001.dbo.PAYMENT_CASH_BOOK_DETAIL
INSERT INTO TamCOMP.dbo.PAYMENT_CASH_BOOK_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.PAYMENT_CASH_BOOK_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.RECEIVED_BANK_BOOK_DETAIL SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_BANK_BOOK_DETAIL
INSERT INTO TamCOMP.dbo.RECEIVED_BANK_BOOK_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_BANK_BOOK_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.RECEIVED_CASH_BOOK_DETAIL SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_CASH_BOOK_DETAIL
INSERT INTO TamCOMP.dbo.RECEIVED_CASH_BOOK_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_CASH_BOOK_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.RECEIVED_RETURN_GOODS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_RETURN_GOODS_DETAIL
INSERT INTO TamCOMP.dbo.RECEIVED_RETURN_GOODS_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_RETURN_GOODS_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.RECEIVED_RETURN_GOODS_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_RETURN_GOODS_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.RECEIVED_RETURN_GOODS_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_RETURN_GOODS_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_RETURN_GOODS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE_RETURN_GOODS_DETAIL
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_RETURN_GOODS_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE_RETURN_GOODS_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_RETURN_GOODS_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE_RETURN_GOODS_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.FINISHED_PURCHASE_RETURN_GOODS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.FINISHED_PURCHASE_RETURN_GOODS_DETAIL
INSERT INTO TamCOMP.dbo.FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.GREY_SEND_TO_MILL SELECT DISTINCT * FROM T20G001.dbo.GREY_SEND_TO_MILL
INSERT INTO TamCOMP.dbo.GREY_SEND_TO_MILL_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_SEND_TO_MILL_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.GREY_SEND_TO_MILL_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_SEND_TO_MILL_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.FINISHED_RECEIVED_FROM_MILL SELECT DISTINCT * FROM T20G001.dbo.FINISHED_RECEIVED_FROM_MILL
INSERT INTO TamCOMP.dbo.FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.FINISHED_RECEIVED_FROM_MILL_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.FINISHED_RECEIVED_FROM_MILL_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.FINISHED_RECEIVED_FROM_MILL_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.FINISHED_RECEIVED_FROM_MILL_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.GP_RECEIVED_FROM_MILL SELECT DISTINCT * FROM T20G001.dbo.GP_RECEIVED_FROM_MILL
INSERT INTO TamCOMP.dbo.GP_RECEIVED_FROM_MILL_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GP_RECEIVED_FROM_MILL_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.GENERAL_PURCHASE SELECT DISTINCT * FROM T20G001.dbo.GENERAL_PURCHASE
INSERT INTO TamCOMP.dbo.GENERAL_PURCHASE_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GENERAL_PURCHASE_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_FINISHED_PURCHASE SELECT DISTINCT * FROM T20G001.dbo.OPENING_FINISHED_PURCHASE
INSERT INTO TamCOMP.dbo.OPENING_GENERAL_PURCHASE SELECT DISTINCT * FROM T20G001.dbo.OPENING_GENERAL_PURCHASE
INSERT INTO TamCOMP.dbo.OPENING_BILL_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_BILL_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_GREY_SEND_TO_MILL SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_SEND_TO_MILL
INSERT INTO TamCOMP.dbo.OPENING_GREY_SEND_TO_MILL_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_SEND_TO_MILL_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_GREY_SEND_TO_MILL_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_SEND_TO_MILL_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_MILL_GP SELECT DISTINCT * FROM T20G001.dbo.OPENING_MILL_GP
INSERT INTO TamCOMP.dbo.OPENING_GREY_PURCHASE SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_PURCHASE
INSERT INTO TamCOMP.dbo.OPENING_SEND_TO_JOB SELECT DISTINCT * FROM T20G001.dbo.OPENING_SEND_TO_JOB
INSERT INTO TamCOMP.dbo.OPENING_SEND_TO_JOB_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_SEND_TO_JOB_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_SEND_TO_JOB_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_SEND_TO_JOB_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_SEND_TO_JOB_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_SEND_TO_JOB_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_SEND_TO_JOB_FINISHED_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_SEND_TO_JOB_FINISHED_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_FINISHED_RECEIVED_FROM_MILL SELECT DISTINCT * FROM T20G001.dbo.OPENING_FINISHED_RECEIVED_FROM_MILL
INSERT INTO TamCOMP.dbo.OPENING_FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_FINISHED_RECEIVED_FROM_MILL_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_FINISHED_RECEIVED_FROM_MILL_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_YARN_RECEIVED_FROM_MILL SELECT DISTINCT * FROM T20G001.dbo.OPENING_YARN_RECEIVED_FROM_MILL
INSERT INTO TamCOMP.dbo.OPENING_YARN_RECEIVED_FROM_MILL_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_YARN_RECEIVED_FROM_MILL_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_YARN_RECEIVED_FROM_MILL_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_YARN_RECEIVED_FROM_MILL_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.ITEM_FINALIZATION SELECT DISTINCT * FROM T20G001.dbo.ITEM_FINALIZATION
INSERT INTO TamCOMP.dbo.ITEM_FINALIZATION_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.ITEM_FINALIZATION_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.JOURNAL_VOUCHER SELECT DISTINCT * FROM T20G001.dbo.JOURNAL_VOUCHER
INSERT INTO TamCOMP.dbo.SEND_TO_JOB SELECT DISTINCT * FROM T20G001.dbo.SEND_TO_JOB
INSERT INTO TamCOMP.dbo.SEND_TO_JOB_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.SEND_TO_JOB_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.SEND_TO_JOB_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.SEND_TO_JOB_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.SEND_TO_JOB_FINISHED_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.SEND_TO_JOB_FINISHED_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.SEND_TO_JOB_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.SEND_TO_JOB_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_RECEIVED_FROM_JOB
INSERT INTO TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_RECEIVED_FROM_JOB_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_RECEIVED_FROM_JOB_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_YARN_CONSUMPTION_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CHALLAN_RECEIVED_FROM_JOB_YARN_CONSUMPTION_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB SELECT DISTINCT * FROM T20G001.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB
INSERT INTO TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_YARN_CONSUMPTION_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_YARN_CONSUMPTION_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_ITEM_SCREEN_COSTING SELECT DISTINCT * FROM T20G001.dbo.OPENING_ITEM_SCREEN_COSTING
INSERT INTO TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL SELECT DISTINCT * FROM T20G001.dbo.OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL
INSERT INTO TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.STOCK_TRANSFER SELECT DISTINCT * FROM T20G001.dbo.STOCK_TRANSFER
INSERT INTO TamCOMP.dbo.STOCK_TRANSFER_DETAIL SELECT DISTINCT * FROM T20G001.dbo.STOCK_TRANSFER_DETAIL
INSERT INTO TamCOMP.dbo.STOCK_TRANSFER_SCREEN_TO_SCREEN SELECT DISTINCT * FROM T20G001.dbo.STOCK_TRANSFER_SCREEN_TO_SCREEN
INSERT INTO TamCOMP.dbo.GREY_RECEIVED_FROM_JOB SELECT DISTINCT * FROM T20G001.dbo.GREY_RECEIVED_FROM_JOB
INSERT INTO TamCOMP.dbo.GREY_RECEIVED_FROM_JOB_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_RECEIVED_FROM_JOB_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.GREY_RECEIVED_FROM_JOB_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_RECEIVED_FROM_JOB_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_FOR_ITEM_FINALIZATION SELECT DISTINCT * FROM T20G001.dbo.OPENING_FOR_ITEM_FINALIZATION
INSERT INTO TamCOMP.dbo.RECEIVED_FROM_JOB SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_FROM_JOB
INSERT INTO TamCOMP.dbo.RECEIVED_FROM_JOB_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.RECEIVED_FROM_JOB_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_RECEIVED_FROM_JOB SELECT DISTINCT * FROM T20G001.dbo.OPENING_RECEIVED_FROM_JOB
INSERT INTO TamCOMP.dbo.OPENING_GREY_AT_SHOP SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_AT_SHOP
INSERT INTO TamCOMP.dbo.OPENING_GREY_AT_SHOP_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_AT_SHOP_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_GREY_AT_SHOP_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_AT_SHOP_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_GREY_AT_SHOP_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_AT_SHOP_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.TDS_TCS_CHALLAN SELECT DISTINCT * FROM T20G001.dbo.TDS_TCS_CHALLAN
INSERT INTO TamCOMP.dbo.TDS_TCS_CHALLAN_TDS_TYPE_DETAIL SELECT DISTINCT * FROM T20G001.dbo.TDS_TCS_CHALLAN_TDS_TYPE_DETAIL
INSERT INTO TamCOMP.dbo.TDS_TCS_CHALLAN_PARTY_DETAIL SELECT DISTINCT * FROM T20G001.dbo.TDS_TCS_CHALLAN_PARTY_DETAIL
INSERT INTO TamCOMP.dbo.BILL_ACCOUNT_TYPES SELECT DISTINCT * FROM T20G001.dbo.BILL_ACCOUNT_TYPES
INSERT INTO TamCOMP.dbo.JOB_ACCOUNT_TYPES SELECT DISTINCT * FROM T20G001.dbo.JOB_ACCOUNT_TYPES
INSERT INTO TamCOMP.dbo.FINISHED_PURCHASE_ACCOUNT_TYPES SELECT DISTINCT * FROM T20G001.dbo.FINISHED_PURCHASE_ACCOUNT_TYPES
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_ACCOUNT_TYPES SELECT DISTINCT * FROM T20G001.dbo.FINISHED_PURCHASE_ACCOUNT_TYPES
INSERT INTO TamCOMP.dbo.RETURN_GOODS_ACCOUNT_TYPES SELECT DISTINCT * FROM T20G001.dbo.RETURN_GOODS_ACCOUNT_TYPES
INSERT INTO TamCOMP.dbo.GREY_RETURN_ACCOUNT_TYPES SELECT DISTINCT * FROM T20G001.dbo.GREY_RETURN_ACCOUNT_TYPES
INSERT INTO TamCOMP.dbo.FINISHED_RETURN_ACCOUNT_TYPES SELECT DISTINCT * FROM T20G001.dbo.GREY_RETURN_ACCOUNT_TYPES
INSERT INTO TamCOMP.dbo.BANK_BOOK_CHEQUE_RETURN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BANK_BOOK_CHEQUE_RETURN_DETAIL
INSERT INTO TamCOMP.dbo.BANK_BOOK_CHEQUE_RETURN_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BANK_BOOK_CHEQUE_RETURN_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.GREY_SEND_TO_MILL_PROGRAM SELECT DISTINCT * FROM T20G001.dbo.GREY_SEND_TO_MILL_PROGRAM
INSERT INTO TamCOMP.dbo.GREY_RETURN_FROM_MILL SELECT DISTINCT * FROM T20G001.dbo.GREY_RETURN_FROM_MILL
INSERT INTO TamCOMP.dbo.GREY_RETURN_FROM_MILL_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_RETURN_FROM_MILL_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.GREY_RETURN_FROM_MILL_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_RETURN_FROM_MILL_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.MILL_ORDER SELECT DISTINCT * FROM T20G001.dbo.MILL_ORDER
INSERT INTO TamCOMP.dbo.MILL_ORDER_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.MILL_ORDER_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_ORDER_FORM SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE_ORDER_FORM
INSERT INTO TamCOMP.dbo.GREY_PURCHASE_ORDER_FORM_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.GREY_PURCHASE_ORDER_FORM_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.FINISHED_PURCHASE_ORDER_FORM SELECT DISTINCT * FROM T20G001.dbo.FINISHED_PURCHASE_ORDER_FORM
INSERT INTO TamCOMP.dbo.FINISHED_PURCHASE_ORDER_FORM_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.FINISHED_PURCHASE_ORDER_FORM_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_FINISHED_PURCHASE_ORDER_FORM SELECT DISTINCT * FROM T20G001.dbo.OPENING_FINISHED_PURCHASE_ORDER_FORM
INSERT INTO TamCOMP.dbo.OPENING_FINISHED_PURCHASE_ORDER_FORM_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_FINISHED_PURCHASE_ORDER_FORM_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.JOB_ORDER_FORM SELECT DISTINCT * FROM T20G001.dbo.JOB_ORDER_FORM
INSERT INTO TamCOMP.dbo.JOB_ORDER_FORM_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.JOB_ORDER_FORM_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_JOB_ORDER_FORM SELECT DISTINCT * FROM T20G001.dbo.OPENING_JOB_ORDER_FORM
INSERT INTO TamCOMP.dbo.OPENING_JOB_ORDER_FORM_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_JOB_ORDER_FORM_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.TDS_CERTIFICATE_DETAIL SELECT DISTINCT * FROM T20G001.dbo.TDS_CERTIFICATE_DETAIL
INSERT INTO TamCOMP.dbo.TDS_CERTIFICATE_TDS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.TDS_CERTIFICATE_TDS_DETAIL
INSERT INTO TamCOMP.dbo.PRINTING_MASTER SELECT DISTINCT * FROM T20G001.dbo.PRINTING_MASTER
INSERT INTO TamCOMP.dbo.ORDER_BILL_DETAIL SELECT DISTINCT * FROM T20G001.dbo.ORDER_BILL_DETAIL
INSERT INTO TamCOMP.dbo.ORDER_BILL_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.ORDER_BILL_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.ORDER_BILL_ITEM_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.ORDER_BILL_ITEM_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_ORDER_BILL_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_ORDER_BILL_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_ORDER_BILL_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_ORDER_BILL_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_ORDER_BILL_ITEM_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_ORDER_BILL_ITEM_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.MULTI_JOURNAL_DETAIL SELECT DISTINCT * FROM T20G001.dbo.MULTI_JOURNAL_DETAIL
INSERT INTO TamCOMP.dbo.MULTI_JOURNAL_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.MULTI_JOURNAL_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_GREY_PURCHASE_ORDER_FORM SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_PURCHASE_ORDER_FORM
INSERT INTO TamCOMP.dbo.OPENING_GREY_PURCHASE_ORDER_FORM_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_GREY_PURCHASE_ORDER_FORM_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.LOST_AT_SHOP SELECT DISTINCT * FROM T20G001.dbo.LOST_AT_SHOP
INSERT INTO TamCOMP.dbo.LOST_AT_SHOP_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.LOST_AT_SHOP_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.SCAN_FINISHED_STOCK SELECT DISTINCT * FROM T20G001.dbo.SCAN_FINISHED_STOCK
INSERT INTO TamCOMP.dbo.OPENING_SCAN_FINISHED_STOCK SELECT DISTINCT * FROM T20G001.dbo.OPENING_SCAN_FINISHED_STOCK
INSERT INTO TamCOMP.dbo.COMPANY_SETTING SELECT DISTINCT * FROM T20G001.dbo.COMPANY_SETTING
INSERT INTO TamCOMP.dbo.MARKING_LEDGER_REPORT SELECT DISTINCT * FROM T20G001.dbo.MARKING_LEDGER_REPORT
INSERT INTO TamCOMP.dbo.RECONCILIATION_HISTORY SELECT DISTINCT * FROM T20G001.dbo.RECONCILIATION_HISTORY
INSERT INTO TamCOMP.dbo.GREY_ITEM_WISE_FINISHED_STOCK SELECT DISTINCT * FROM T20G001.dbo.GREY_ITEM_WISE_FINISHED_STOCK
INSERT INTO TamCOMP.dbo.OPENING_WITHOUT_WORK_STOCK SELECT DISTINCT * FROM T20G001.dbo.OPENING_WITHOUT_WORK_STOCK
INSERT INTO TamCOMP.dbo.BILLS_INTEREST_CALCULATION SELECT DISTINCT * FROM T20G001.dbo.BILLS_INTEREST_CALCULATION
INSERT INTO TamCOMP.dbo.BILLS_INTEREST_CALCULATION_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BILLS_INTEREST_CALCULATION_DETAIL
INSERT INTO TamCOMP.dbo.ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.FIRM_ADDLESS_DETAIL SELECT DISTINCT * FROM T20G001.dbo.FIRM_ADDLESS_DETAIL
INSERT INTO TamCOMP.dbo.CUTTING_AFTER_JOB SELECT DISTINCT * FROM T20G001.dbo.CUTTING_AFTER_JOB
INSERT INTO TamCOMP.dbo.CUTTING_AFTER_JOB_DETAIL SELECT DISTINCT * FROM T20G001.dbo.CUTTING_AFTER_JOB_DETAIL
INSERT INTO TamCOMP.dbo.CONSUMPTION_MODULE SELECT DISTINCT * FROM T20G001.dbo.CONSUMPTION_MODULE
INSERT INTO TamCOMP.dbo.CONSUMPTION_ITEM_MODULE SELECT DISTINCT * FROM T20G001.dbo.CONSUMPTION_ITEM_MODULE
INSERT INTO TamCOMP.dbo.CONSUMPTION_PROCESSING_MODULE SELECT DISTINCT * FROM T20G001.dbo.CONSUMPTION_PROCESSING_MODULE
INSERT INTO TamCOMP.dbo.OPENING_LR_GREY_PURCHASE SELECT DISTINCT * FROM T20G001.dbo.OPENING_LR_GREY_PURCHASE
INSERT INTO TamCOMP.dbo.OPENING_LR_GREY_PURCHASE_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_LR_GREY_PURCHASE_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.OPENING_LR_GREY_PURCHASE_ITEM_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.OPENING_LR_GREY_PURCHASE_ITEM_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.BARCODE_STOCK SELECT DISTINCT * FROM T20G001.dbo.BARCODE_STOCK
INSERT INTO TamCOMP.dbo.BARCODE_STOCK_ITEM_DETAIL SELECT DISTINCT * FROM T20G001.dbo.BARCODE_STOCK_ITEM_DETAIL
INSERT INTO TamCOMP.dbo.YARN_PRODUCTION SELECT DISTINCT * FROM T20G001.dbo.YARN_PRODUCTION
INSERT INTO TamCOMP.dbo.YARN_PRODUCTION_CHALLAN_DETAIL SELECT DISTINCT * FROM T20G001.dbo.YARN_PRODUCTION_CHALLAN_DETAIL
INSERT INTO TamCOMP.dbo.YARN_PRODUCTION_YARN_TAKA_DETAIL SELECT DISTINCT * FROM T20G001.dbo.YARN_PRODUCTION_YARN_TAKA_DETAIL
INSERT INTO TamCOMP.dbo.YARN_PRODUCTION_YARN_CONSUMPTION_DETAIL SELECT DISTINCT * FROM T20G001.dbo.YARN_PRODUCTION_YARN_CONSUMPTION_DETAIL
INSERT INTO TamCOMP.dbo.UPDATE_DETAIL SELECT DISTINCT * FROM T20G001.dbo.UPDATE_DETAIL