Felipe Finhane de Paula felipefinhane

felipefinhane / novas_permissoes_historico_padrao.sql

Last active March 19, 2018 18:50 — forked from suspecie/novas_permissoes_historico_padrao.sql

	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);