Each year new id

Hi,

Please refer below code.

SQL

DECLARE @RegisterTable AS TABLE(Id INT,Name VARCHAR(50),[Date] DATETIME)

INSERT INTO @RegisterTable VALUES(101,'Rustam','2016.12.22')
INSERT INTO @RegisterTable VALUES(102,'Sadriddin','2016.12.25')
INSERT INTO @RegisterTable VALUES(103,'Firuz','2016.12.31')
INSERT INTO @RegisterTable VALUES(104,'Asror','2017.01.01')
INSERT INTO @RegisterTable VALUES(105,'Nurullo','2017.01.03')
INSERT INTO @RegisterTable VALUES(106,'Karomatullo','2017.12.05')

SELECT * FROM @RegisterTable

SELECT ROW_NUMBER() OVER(PARTITION BY DATEPART(YEAR,[Date]) ORDER BY ID) as Id
	,[Name]
	,[Date] 
FROM @RegisterTable

Screenshot