Click here to Skip to main content
       

Database

 
GeneralRe: sql script PinmemberJ4amieC27-Sep-12 2:06 
QuestionLine line is a select statement. Pinmembervanikanc26-Sep-12 9:22 
AnswerRe: Line line is a select statement. Pinmemberjschell26-Sep-12 9:37 
GeneralRe: Line line is a select statement. Pinmembervanikanc26-Sep-12 9:39 
GeneralRe: Line line is a select statement. Pinmemberjschell27-Sep-12 10:57 
AnswerRe: Line line is a select statement. PinmemberNiju126-Sep-12 23:28 
AnswerRe: Line line is a select statement. Pinmemberihoecken27-Sep-12 0:04 
QuestionAttendance and leave of employees PinmemberAmr Muhammed25-Sep-12 14:06 
Greetings,
 
I have 3 tables respectively called "Employee_Personal_Info", "Employee_Job_Info" and "Attend_and_Leave_Of_Staff". The Last table contains a log from the fingerprint device and its columns are [Record Number], [Machine ID], [Employee ID], [In/Out Mode] which contains only 0 for attend and 1 for leave, [Verify Mode] which contains only 1 for fingerprint and 15 for face, [Date] and [Time]
 
Columns concern me here within those tables are
1- Employee_Personal_Info: [Employee ID], [First Name], [Middle Name], [Last Name] and [Family Name]
2- Employee_Job_Info: [Job title], [Shift ID]
3- Attend_And_Leave_Of_Staff: [Date], [Time]
 
We have 2 work shifts one that starts and ends in the same date begin at 8:00 AM and ends at 4:00 PM and the other begin at 6:30 PM and ends on the next day at 8:00 AM.
 
I need to create a SQL query that returns me all employees registered on a specific work shift with their attend and leave time. That is it when selecting a specific type of shift the query returns me all the employees registered in such shift and beside each one his attend/leave date/time and returns null if one of the date/time is not found and null for both if there is no attendance data for him. I know it may be a complex query specially when dealing with employees registered in the second shift that starts at a day and ends on another one. I will be grateful for any ideas or any help
AnswerRe: Attendance and leave of employees [modified] Pinmemberihoecken25-Sep-12 21:50 
GeneralRe: Attendance and leave of employees [modified] PinmemberAndrei Straut25-Sep-12 22:03 
GeneralRe: Attendance and leave of employees Pinmemberihoecken25-Sep-12 22:19 
GeneralRe: Attendance and leave of employees PinmemberAndrei Straut25-Sep-12 22:20 
QuestionConvert datetime to certain format Pinmembervanikanc25-Sep-12 10:09 
AnswerRe: Convert datetime to certain format Pinmemberihoecken25-Sep-12 21:58 
QuestionSql server topics and materials PinmemberAzizullahazizi24-Sep-12 19:32 
AnswerRe: Sql server topics and materials PinmemberAndrei Straut24-Sep-12 21:12 
AnswerRe: Sql server topics and materials PinmvpSandeep Mewara24-Sep-12 21:23 
QuestionSQL Search within a table Pinmemberveon cheng24-Sep-12 10:31 
AnswerRe: SQL Search within a table Pinmemberdjj5525-Sep-12 2:08 
GeneralRe: SQL Search within a table Pinmemberveon cheng25-Sep-12 4:37 
AnswerRe: SQL Search within a table Pinmemberihoecken25-Sep-12 5:13 
QuestionCONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberr_mohd22-Sep-12 23:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE PinmemberEddy Vluggen23-Sep-12 3:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberjschell23-Sep-12 9:10 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberr_mohd24-Sep-12 3:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.141223.1 | Last Updated 26 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid