Adding previous or next row values based on condition

[eyobzeleke]

any inputs on this? Concurrency issue, Stored Procedure, Table Valued Function