@gilamonster

Nice to know - but this code doesn't work in functions

Thanks for your tips.

The Sequenze-Function looks nice - but the function is not available for SQLServer 2005.

I just should explain my problem again.

Basically there is a procedure which creates orders...

GilaMonster (9/8/2016)[/b]

While it talks about insert/update pairs, your manual sequence code will have the same problems.

Edit: And if you need an incrementing value that starts at 5,

SomeNumber INT IDENTITY (5,1)

I...

Yes of course, my first idea was an IDENTITY() column.

But i need two different numbers - one is starting with 1 and the other is starting with 5.

Therefore i adjust...