• Each entity has successive periods. They can continue forever.

    Your CTE is adding the total suspension duration in the first period. The solution must apply the suspension to the correct period and adjust the start and end dates of the following period (with suspensions occurring in that period applied) as indicated in the result set I supplied in the initial post.