SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure [dbo].[p_mail_get_smtp_params_by_branch_id]
	@branch_id int
as
	set nocount on

	select	s.*
	from	nm_smtp_servers s
			inner join act_branches b on b.br_smtpserver_code = s.smtp_smtpserver_code
	where	b.br_actor_id = @branch_id
			
GO
