Apologies if this was already mentioned...something akin to Oracle's LAG function that can optionally be accumulated in a variable. This would obviate the need for CLR and triangluar joins for...