How To Get Employee Absent Report

Question

Hello I Have The Employee In Out Data In Sql Table Like 1 2017-12-11 1900-01-01 08:38:38.000 OUT 2 2017-12-11 1900-01-01 08:39:21.000 IN 3 2017-12-11 1900-01-01 08:41:06.000 OUT 4 2017-12-11 1900-01-01 08:42:13.000 IN I Have To Generate The Absent Report Ignoring The Sundays And Second Fourth Saturday For Example Emp Id Name Absent Dates 1 ABC 1/1/2018

Nitin Sontakke · Answer

Is this an home-work assignment or a real life requirement. If it is a real life requirement I suggest that you generate a professional quality report and not just a list with employee Id name and absent dates. Will you agree? If yes please do let me know and we will take it from there.

Sanwar Ranwa · Answer

not understand your query

Joseph Thomas · Answer

This is logic to find absentees in a day...Check if this helps you.. select emp_idemp_name from emp_table where emp_id not in (select id from emp_in_out_table where punching_time >=' 2017-12-11 00:00:00' and punching_time

Laxmidhar Sahoo · Answer

pl send table structure

Nilesh Yadav · Answer

Please mention All Information about Table Like Column Name Table Name etc and Give Professional Report about Your Question.

Altaf Ansari · Answer

Please try this : Select Emp Id Name  Date from Employee where InTime= null and OutTime= null ;