我已经编写了一条SQL查询语句,用于查找缺勤的员工。但是我如何显示日期,也就是缺勤期间的日期?它可以正常运行,除了日期。我想显示缺勤期间的具体日期,但是无法显示。
样例:
样例:
BadgeNumber - EmployeeName - Absent Date
10042 - Mr. Erik - 2014-07-01
代码:
SELECT SMEmployee.BadgeNumber,SMEmployee.EmployeeFullName,SMDepartment.DepartmentName
FROM SMEmployee
LEFT OUTER JOIN SMDepartment
ON SMDepartment.DepartmentID=SMEmployee.DepartmentID
WHERE EmployeeID NOT IN (
SELECT empCheckInOut.USERID
FROM empCheckInOut
WHERE convert(date,CHECKTIME)='2014-07-01')