Recursive sql

What is the version of your SQL Server? Is it 2012? Or older?

Because if the version you have is 2012 then you can use running aggregates to solve this quite easily (pretty much what CELKO suggested). But if not then you'd need to use some kind of recursive CTE.

P.S.

--CELKO-- you're being very rude in your replies. This is not facebook or youtube or twitter where you can belittle people like that. This is a professional forum to be used by inexperienced SQL Server users to get help from experienced users. This is not the place to insult people by saying they "failed in the worst ways". I appreciate your professional advice but I hope I'm not overstepping myself here when I say you could use a different tone in your comments.

---

Eitan Blumin; SQL Server Consultant - Madeira SQL Server Services; http://www.madeira.co.il/author/eitan/