I have a table like below by name Tasks.
TaskId | StartDate | EndDate |
---|---|---|
Task1 | 2020-01-01 09:00:00.00 | 2020-01-15 18:00:00.000 |
Task2 | 2020-01-04 09:00:00.00 | 2020-01-19 18:00:00.000 |
Task3 | 2020-01-09 09:00:00.00 | 2020-01-21 18:00:00.000 |
Task4 | 2020-01-12 09:00:00.00 | 2020-01-21 18:00:00.000 |
Task5 | 2020-02-02 09:00:00.00 | 2020-02-05 18:00:00.000 |
Task6 | 2020-01-23 09:00:00.00 | 2020-01-18 18:00:00.000 |
Task7 | 2020-02-05 09:00:00.00 | 2020-02-24 18:00:00.000 |