Thanks,

SPGetNextSequence return a value from a table then update it's value.

everything worked fine once I put a ORDER BY a Identity Column in the declare cursor statement.

so instead of

DECLARE...