I know sql server can set a field to be auto incremental by a variable (1,2,3,4...) or (1,3,5...)
But what i need to do is auto increment of 1 group by another field.
Eg. I have 2 fields in 1 table: that call the field JobNo and SeqNo. For all record under same job, i want the seqNo field to be incremental within that job no. This mean i want a different set of seqno for different job.
Can i do this in SQL server incrmental field?