absence dates, Sql Server - rextester

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

absence dates

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 4, rows affected: 12, absolute service time: 0,17 sec

edit mode | history

  
EMPLOYEE_ID
ITEM_TYPE
STARTDATE
ENDDATE

1
1
Sickness
23.05.2017 00:00:00
24.05.2017 00:00:00

2
1
Sickness
01.06.2017 00:00:00
01.06.2017 00:00:00

3
1
Vacation
26.05.2017 00:00:00
29.05.2017 00:00:00

4
2
Sickness
25.05.2017 00:00:00
30.05.2017 00:00:00

λ

                                      .NET NoSQL database for rapid development