Click here to Skip to main content
15,789,700 members
Home / Discussions / Database
   

Database

 
AnswerRe: About MySQL table permission removal failed Pin
Richard Deeming13-Jun-21 23:09
mveRichard Deeming13-Jun-21 23:09 
QuestionSandwich Query For Employee Attendance using SQL Server 2005 Pin
Mohammad Salmani8-Jun-21 21:40
Mohammad Salmani8-Jun-21 21:40 
AnswerRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Richard MacCutchan8-Jun-21 22:55
mveRichard MacCutchan8-Jun-21 22:55 
AnswerRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp29-Jun-21 2:35
SeeSharp29-Jun-21 2:35 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mohammad Salmani9-Jun-21 4:08
Mohammad Salmani9-Jun-21 4:08 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp29-Jun-21 4:39
SeeSharp29-Jun-21 4:39 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
David Mujica9-Jun-21 5:25
David Mujica9-Jun-21 5:25 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mycroft Holmes9-Jun-21 13:36
professionalMycroft Holmes9-Jun-21 13:36 
I would do the as 3 queries:

1 get the first absent date date - store it in date1 variable
2 get the next absent date > date 1 - if it exists store it in date2 variable
If date2 is not null (more than 1 day)
3 set all records between date1 and date2 to absent

This covers multi day holidays.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp210-Jun-21 2:25
SeeSharp210-Jun-21 2:25 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mycroft Holmes10-Jun-21 13:09
professionalMycroft Holmes10-Jun-21 13:09 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
Mohammad Salmani10-Jun-21 22:53
Mohammad Salmani10-Jun-21 22:53 
GeneralRe: Sandwich Query For Employee Attendance using SQL Server 2005 Pin
SeeSharp211-Jun-21 2:20
SeeSharp211-Jun-21 2:20 
QuestionLoad JSON file from network location Pin
Member 144746073-Jun-21 8:36
Member 144746073-Jun-21 8:36 
AnswerRe: Load JSON file from network location Pin
Member 144746073-Jun-21 9:42
Member 144746073-Jun-21 9:42 
AnswerRe: Load JSON file from network location Pin
Mycroft Holmes3-Jun-21 13:15
professionalMycroft Holmes3-Jun-21 13:15 
QuestionSQL Server 2010, smalldatetime insert Pin
jkirkerx1-Jun-21 15:52
professionaljkirkerx1-Jun-21 15:52 
AnswerRe: SQL Server 2010, smalldatetime insert Pin
Mycroft Holmes1-Jun-21 22:31
professionalMycroft Holmes1-Jun-21 22:31 
AnswerRe: SQL Server 2010, smalldatetime insert Pin
Victor Nijegorodov1-Jun-21 22:49
Victor Nijegorodov1-Jun-21 22:49 
AnswerRe: SQL Server 2010, smalldatetime insert Pin
jkirkerx2-Jun-21 9:47
professionaljkirkerx2-Jun-21 9:47 
QuestionGet columns name Pin
_Flaviu28-May-21 0:55
_Flaviu28-May-21 0:55 
AnswerRe: Get columns name Pin
Victor Nijegorodov28-May-21 1:22
Victor Nijegorodov28-May-21 1:22 
GeneralRe: Get columns name Pin
_Flaviu3-Jun-21 6:57
_Flaviu3-Jun-21 6:57 
GeneralRe: Get columns name Pin
Victor Nijegorodov3-Jun-21 21:13
Victor Nijegorodov3-Jun-21 21:13 
GeneralRe: Get columns name Pin
_Flaviu3-Jun-21 21:37
_Flaviu3-Jun-21 21:37 
GeneralRe: Get columns name Pin
Victor Nijegorodov3-Jun-21 22:48
Victor Nijegorodov3-Jun-21 22:48 

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.