felipefinhane

TRUNCATE AccountingBalanceSheetLayoutEnvironment;
INSERT INTO AccountingBalanceSheetLayoutEnvironment(id_balanco_contabil_layout, id_empresa) SELECT
	id_balanco_contabil_layout ,
	c.id_empresa
FROM
	AccountingBalanceSheetLayoutMainData a
LEFT JOIN CorporationMainData c ON c.stat <> 0;

TRUNCATE AccountingBalanceSheetLayoutProfile;

felipefinhane

DELETE FROM AccountingTransactionDescriptionProfile;

INSERT INTO AccountingTransactionDescriptionProfile (id_descricao_transacao_contabil, id_perfil) SELECT 
    id_descricao_transacao_contabil, p.id_perfil
FROM
    AccountingTransactionDescriptionMainData
        LEFT JOIN  ProfileMainData p ON 1 = 1
WHERE
    p.id_perfil IN (62 , 146, 120, 117, 114, 98);