I was looking for a way to solve a similar problem, after some research, this is what I came up with:

1st, create a table like this one,

CREATE TABLE [dbo].[tblUniqueID] (

 [SeqYear]...