ALTER procedure [dbo].[Late]
as
declare @date_time_now datetime
set @date_time_now=getdate()
if exists (select * from Calendar where [date]=cast(@date_time_now as date) and is_holiday=1)
	return

exec Update_Employee_cardno_acedb

declare @t table (rw nvarchar(100), nm nvarchar(100), ps nvarchar(100), st char(10), et char(10))
declare @rw nvarchar(100),@nm nvarchar(100),@ps nvarchar(100),@st char(10),@et char(10),@dpt nvarchar(100),@dpt_ nvarchar(100)
set @dpt_=''
declare cur_late cursor for
		select	ROW_NUMBER() over (order by d.id) rn,
				e.last_name+' '+e.first_name+' '+isnull(e.middle_name,'') [name],
				isnull(p.position_name,'-') position,
				t.start_time,
				coalesce(convert(char(5),ev.et,14),'-') event_time,
				d.dept_name
		from Employees.dbo.Employees e
		left join Employees.dbo.EmployeeStartTime t
			on e.employee_start_time_id=t.id
		left join Employees.dbo.EmployeePosition p
			on e.position_id=p.id
		inner join Employees.dbo.Department d
			on e.dept_id=d.id
		left join
		(
			select e.stringValue cardno, min(e.eventCreationTime) et
			from BIS.BISEventLog.dbo.vw_LogEvent e
			where e.eventCreationTime between 
						convert(char(11),@date_time_now,21)+'01:00' and @date_time_now
					and e.addressId in (8444,77,16471,16472,16631,16632,18606,18608) -- вход
					and e.eventValueName='CARDNO'
					and e.eventtypeid=1
			group by e.stringValue
		) ev 
			on ev.cardno=e.card_no collate Latin1_General_CI_AS
		where e.active=1
				and (ev.et>convert(char(11),@date_time_now,21)+dateadd(minute,5,t.start_time)--'08:34:59' 
						or ev.et is null)

 and e.id not in(1,2,3)