Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

TSQL - Gaps and islands with work weeks and breaks problem

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 5, rows affected: 11, absolute service time: 0,19 sec 
edit mode |  history
   Employee WorkDateStart workWeeks breakWeeks
1 123 01/04/2016 1 2
2 123 01/27/2016 1 5
3 123 03/09/2016 1 1
4 123 03/25/2016 2 1
5 123 04/10/2016 1 NULL

    
                
λ
.NET NoSQL database for rapid development