• What is the value of this column, EC.EECPAYPERIOD, in EMPCOMP for the parameters @COID and @EEID passed to this function where the calculations are incorrect.

    The value of EC.EECPAYPERIOD is 'B'

    which I know calcs at 26

    So I tried updating one of the records to 'S' but when I did that it did a strange thing put the value in 'Monthly_EE_AMT'.

    The intersting part is that it was the correct amount now when using 'S'- but wrong field..