获得特定月份所有员工的休假报告 [英] Getting leave report of all employees for a particular month

问题描述

您好



任何人都可以帮我解决如何撰写查询以获取特定月份员工的休假报告。





每个员工都需要每天检查员工休假申请表，如果该表中存在日期，则应该返回休假类型。 div class =h2_lin>解决方案

这只是一个合理的解决方案，因为你没有提供数据模态。

 选择 leave_date，leave_type 来自 leave_table 其中月（leave_date）= @ LeaveReportMonth 和月（leave_date）= @ LeaveReportYear 

Hi

Can any one help me out how to write a query for getting leave report of employee for a particular month.


every employee needs to be checked in employee leave applications table for a every day and if the date is existing in that table it should return the type of the leave.

解决方案

This is just a logical solution as you have not provided the Data modal.

Select leave_date, leave_type from leave_table where Month(leave_date)=@LeaveReportMonth and Month(leave_date)=@LeaveReportYear

这篇关于获得特定月份所有员工的休假报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！