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.....
Sequence generator
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore