Hello,

Depending on your requirements I'd probably make that seq_no field an identity column.

CREATE TABLE dbo.test ( acct_id INT

...