I want to use an insert statement to add a number of rows of data to a table. The Primary key is the CustomerID and Seqn fields. The seqn field is a simple incrementing number for each customer (starting from 1).
What sort of T-SQL is needed to use with an insert statement to start the number from the next available integer when appending records? As I could be adding for multiple customers and the next seqn for each may well be different.