SQL I have the following data in which I have duration and predecessors for my activities. Now I want to calculate the start and end date of activities with reference to their predecessors. The data is sampled below. Also please note there might be activities which may not have predecessors so their start date should be @startDate and end date should be calculated from their duration and sundays should be excluded.
Sample Data
https://i.imgur.com/JWTEO59.png
Required Data
https://i.imgur.com/6mbtTzo.png
Please provide me the solution asap.
Thanks.