StackOverflow question #41675257, Sql Server - rextester

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

StackOverflow question #41675257

Language: Layout:

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

edit mode | history

  
AssignmentStart
AssignmentEnd
day
week
StartInCurrentWeek
EndInCurrentWeek

1
01.01.1900 02:30:00
01.01.1900 06:30:00
1
1
22.01.2017 02:30:00
22.01.2017 06:30:00

2
01.01.1900 05:30:00
01.01.1900 13:00:00
1
1
22.01.2017 05:30:00
22.01.2017 13:00:00

3
01.01.1900 04:00:00
01.01.1900 09:30:00
2
1
23.01.2017 04:00:00
23.01.2017 09:30:00

4
01.01.1900 14:30:00
01.01.1900 19:30:00
2
1
23.01.2017 14:30:00
23.01.2017 19:30:00

λ

                                      .NET NoSQL database for rapid development