Hi,

I need to generate consecutive numbers in a table but the identity column has already been used. What methods do you guys use to generate a next number?

Thanks