Click here to Skip to main content
15,741,310 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

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.

1 solution

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
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900