• I meant this by quirky update :

    Update table set @Var = UpdatedColumn = @Var + WhateverIttakesToEvalutateThisVariable

    This must be used with a index hint on a temp table to be sure that nothing goes wrong...

    That's a way to make a running total... the case statement here would be quite interesting though ;-P.