SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create procedure [dbo].[p_test_trnb_delete]
as 

	update acc_trn_bordereaux set trnb_tmp = 1
	
	delete acc_trn_bordereaux_introducers
	delete acc_trn_bordereaux_departments
	delete acc_trn_bordereaux_companies

	delete acc_trn_bordereaux_details
	delete acc_trn_bordereaux_accounts

	delete acc_trn_bordereaux
GO
