I am writing a calculation view, and unfortunately, I must loop over a table variable, because I need to update a row on the current row based on the value of the prior row (old COBOL control break logic). How do I do this? I tried to use a cursor and it did not work.
P.S. I already know that this will not be the efficient, but it is the only way that I can think of to accomplish my task.