I need to have some how 2 identity columns in one table. One that is normal identity and another one that will reset yearly.
I have done the reset part with the help of
DBCC CHECKIDENT ('TestTable', RESEED, 0) in the insert procedure.
But I don't know how to have a normal identity besides this one. Solution may be using two tables but I prefer to have both of them in a single table.