Try looking at recursive CTE or adjacency model to start. There's plenty of good articles on SSC on what you want to do.

[Edit]

Oops yeah that works. Didn't read the req. clearly, I thought you wanted to append the values like a string. Summing it is a lot easier... 🙂