Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Incremented values

Author  Topic  carraj Starting Member 1 Post Posted - 2001-10-15 : 12:21:39 I need to populate a field with an incremented number. There will be one plus records in each "group" I need to populate. Each group needs to begin with 16384 and be increased by 32768 for each additional record in the group. E.g. there could be several invoice lines per invoice number. Each invoice line needs this number appended to it. By group (above) I mean a set of records with the same invoice number. If anyone can even get there head round what I mean, I would greatly appreciate any help on offer.