Click here to Skip to main content
13,202,262 members (56,666 online)
   

Database

 
GeneralRe: sql script Pin
sindhuan26-Sep-12 21:21
membersindhuan26-Sep-12 21:21 
AnswerRe: sql script Pin
ihoecken26-Sep-12 21:44
memberihoecken26-Sep-12 21:44 
AnswerRe: sql script Pin
J4amieC26-Sep-12 21:46
memberJ4amieC26-Sep-12 21:46 
GeneralRe: sql script Pin
sindhuan26-Sep-12 23:30
membersindhuan26-Sep-12 23:30 
AnswerRe: sql script Pin
ihoecken27-Sep-12 0:07
memberihoecken27-Sep-12 0:07 
GeneralRe: sql script Pin
Eddy Vluggen27-Sep-12 0:22
memberEddy Vluggen27-Sep-12 0:22 
GeneralRe: sql script Pin
J4amieC27-Sep-12 1:06
memberJ4amieC27-Sep-12 1:06 
QuestionLine line is a select statement. Pin
vanikanc26-Sep-12 8:22
membervanikanc26-Sep-12 8:22 
AnswerRe: Line line is a select statement. Pin
jschell26-Sep-12 8:37
memberjschell26-Sep-12 8:37 
GeneralRe: Line line is a select statement. Pin
vanikanc26-Sep-12 8:39
membervanikanc26-Sep-12 8:39 
GeneralRe: Line line is a select statement. Pin
jschell27-Sep-12 9:57
memberjschell27-Sep-12 9:57 
AnswerRe: Line line is a select statement. Pin
Niju126-Sep-12 22:28
memberNiju126-Sep-12 22:28 
AnswerRe: Line line is a select statement. Pin
ihoecken26-Sep-12 23:04
memberihoecken26-Sep-12 23:04 
QuestionAttendance and leave of employees Pin
Amr Muhammed25-Sep-12 13:06
memberAmr Muhammed25-Sep-12 13: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 Pin
ihoecken25-Sep-12 20:50
memberihoecken25-Sep-12 20:50 
GeneralRe: Attendance and leave of employees Pin
Andrei Straut25-Sep-12 21:03
memberAndrei Straut25-Sep-12 21:03 
GeneralRe: Attendance and leave of employees Pin
ihoecken25-Sep-12 21:19
memberihoecken25-Sep-12 21:19 
GeneralRe: Attendance and leave of employees Pin
Andrei Straut25-Sep-12 21:20
memberAndrei Straut25-Sep-12 21:20 
QuestionConvert datetime to certain format Pin
vanikanc25-Sep-12 9:09
membervanikanc25-Sep-12 9:09 
AnswerRe: Convert datetime to certain format Pin
ihoecken25-Sep-12 20:58
memberihoecken25-Sep-12 20:58 
QuestionSql server topics and materials Pin
Azizullahazizi24-Sep-12 18:32
memberAzizullahazizi24-Sep-12 18:32 
AnswerRe: Sql server topics and materials Pin
Andrei Straut24-Sep-12 20:12
memberAndrei Straut24-Sep-12 20:12 
AnswerRe: Sql server topics and materials Pin
Sandeep Mewara24-Sep-12 20:23
mvpSandeep Mewara24-Sep-12 20:23 
QuestionSQL Search within a table Pin
veon cheng24-Sep-12 9:31
memberveon cheng24-Sep-12 9:31 
AnswerRe: SQL Search within a table Pin
djj5525-Sep-12 1:08
memberdjj5525-Sep-12 1:08 
GeneralRe: SQL Search within a table Pin
veon cheng25-Sep-12 3:37
memberveon cheng25-Sep-12 3:37 
AnswerRe: SQL Search within a table Pin
ihoecken25-Sep-12 4:13
memberihoecken25-Sep-12 4:13 
QuestionCONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
r_mohd22-Sep-12 22:38
memberr_mohd22-Sep-12 22:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
Eddy Vluggen23-Sep-12 2:38
memberEddy Vluggen23-Sep-12 2:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell23-Sep-12 8:10
memberjschell23-Sep-12 8:10 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
r_mohd24-Sep-12 2:28
memberr_mohd24-Sep-12 2:28 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell24-Sep-12 12:37
memberjschell24-Sep-12 12:37 
QuestionDb over internet Pin
leone22-Sep-12 8:56
memberleone22-Sep-12 8:56 
AnswerRe: Db over internet Pin
Eddy Vluggen23-Sep-12 0:42
memberEddy Vluggen23-Sep-12 0:42 
AnswerRe: Db over internet Pin
jschell23-Sep-12 8:16
memberjschell23-Sep-12 8:16 
GeneralRe: Db over internet Pin
leone24-Sep-12 0:45
memberleone24-Sep-12 0:45 
GeneralRe: Db over internet Pin
Jörgen Andersson24-Sep-12 2:05
memberJörgen Andersson24-Sep-12 2:05 
AnswerRe: Db over internet Pin
Chris Quinn27-Sep-12 2:36
memberChris Quinn27-Sep-12 2:36 
Questionconnection of mssql 2008 to cloud in windows form application Pin
KUNWAR99921-Sep-12 3:28
memberKUNWAR99921-Sep-12 3:28 
AnswerRe: connection of mssql 2008 to cloud in windows form application Pin
David Mujica21-Sep-12 3:50
memberDavid Mujica21-Sep-12 3:50 
AnswerRe: connection of mssql 2008 to cloud in windows form application Pin
Eddy Vluggen21-Sep-12 4:44
memberEddy Vluggen21-Sep-12 4:44 
QuestionSQL XP_StartSMTP to send email Pin
MWRivera20-Sep-12 5:45
memberMWRivera20-Sep-12 5:45 
AnswerRe: SQL XP_StartSMTP to send email Pin
Chris Meech21-Sep-12 2:45
memberChris Meech21-Sep-12 2:45 
AnswerRe: SQL XP_StartSMTP to send email Pin
Eddy Vluggen21-Sep-12 4:47
memberEddy Vluggen21-Sep-12 4:47 
QuestionContinuous absent query Pin
RA|-|UL PATEL20-Sep-12 3:16
memberRA|-|UL PATEL20-Sep-12 3:16 
AnswerRe: Continuous absent query Pin
djj5520-Sep-12 8:04
memberdjj5520-Sep-12 8:04 
AnswerRe: Continuous absent query Pin
HiteshDR5-Nov-12 23:24
memberHiteshDR5-Nov-12 23:24 
Questionhow to update combobox values in msaccess tables in ACCESS2007 Pin
sowmya4919-Sep-12 20:40
membersowmya4919-Sep-12 20:40 
QuestionSpecifying Seed Values on model building Pin
solomon20118-Sep-12 5:34
membersolomon20118-Sep-12 5:34 
AnswerRe: Specifying Seed Values on model building Pin
Simon_Whale18-Sep-12 5:47
memberSimon_Whale18-Sep-12 5:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 |
Web04 | 2.8.171020.1 | Last Updated 20 Oct 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid