Sequence generator

[venkates.dw]

Hi,

in server jobs sequence generation purpose we use @inrownum. suppose when i am executing first time it will generate sequence numbers. Suppose i am executing once again for appending the records again it will generate from 1 2 3 ...... . but i need continution from alreay existing numbers.

Give me the solution please...

thanks.....

[chulett]

You don't use @INROWNUM as the actual sequence number but rather the offset from a starting point. That starting point is passed in as a job parameter and is the maximum value currently in use in your target that you look up before the job starts. Then simply add @INROWNUM to that job parameter.

[DS_SUPPORT]

Or Use the supplied KeyMgmt Routines.