• Sorry for replying after so long, but I found an easy solution for this and I liked to share it here, perhaps it help someone in future.

    DECLARE @factorial int

    SET @factorial = 0

    UPDATE tableName

    SET @factorial = value = @factorial + value --value is column name

    If you want to store factorial value in seperate column in each row:

    DECLARE @factorial int

    SET @factorial = 0

    UPDATE tableName

    SET @factorial = seperateColumn = @factorial + value --value is column name

    ___________________________________
    Computer Enterprise Masoud Keshavarz
    I don't care about hell.
    If I go there I've played enough Diablo to know how to fight my way out.