---

SELECT TOP 20
    p.TabNum AS [Табельный номер],
    p.FName AS [Фамилия],
    p.Name AS [Имя],
    e.TimeEv AS [Время события],
    e.EventCode AS [Код события],
    e.EventRemark AS [Описание]
FROM pEvents e
LEFT JOIN pList p ON e.HozOrgan = p.ID
WHERE e.TimeEv >= CAST(GETDATE() AS DATE) -- события за сегодня
ORDER BY e.TimeEv DESC;