SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE #test (ID int,
                    code int,
                    InsertDate datetime2);

INSERT INTO #test
VALUES (1, 1, '2019-09-17 03:19:00.0000000'),
       (1, 1, '2019-09-17 03:19:00.0000000'),
       (1, 1, '2019-09-17 03:19:00.0000000'),
       (2, 1, '2019-09-17 03:19:00.0000000'),
       (3, 1, '2019-09-17 03:19:00.0000000');
5 rows affected

SELECT ID,
       code,
       InsertDate,
       SIGN(ROW_NUMBER() OVER (PARTITION BY ID, code, InsertDate ORDER BY InsertDate) - 1) AS flag
FROM #test;


ID
code
InsertDate
flag


1
1
2019-09-17 03:19:00.0000000
0

1
1
2019-09-17 03:19:00.0000000
1

1
1
2019-09-17 03:19:00.0000000
1

2
1
2019-09-17 03:19:00.0000000
0

3
1
2019-09-17 03:19:00.0000000
0


DROP TABLE #test;

ID	code	InsertDate	flag
1	1	2019-09-17 03:19:00.0000000	0
1	1	2019-09-17 03:19:00.0000000	1
1	1	2019-09-17 03:19:00.0000000	1
2	1	2019-09-17 03:19:00.0000000	0
3	1	2019-09-17 03:19:00.0000000	0