SQL Server 2014

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

CREATE TABLE ron_UserRights_Log (
    event_id INT IDENTITY(1,1) PRIMARY KEY,
	idDenyRight INT,
	strUserID VARCHAR(100),
	strRight VARCHAR(100),
	strRole VARCHAR(100),
	strEvent VARCHAR(100),
	old_bDeleted VARCHAR(10),
	new_bDeleted VARCHAR(10),
	ts DATETIME DEFAULT GETDATE()
 );
INSERT INTO ron_UserRights_Log (idDenyRight , strUserID, strRight, strRole, strEvent, old_bDeleted,new_bDeleted,ts) 
VALUES
	(915, 24, 4, 1, 'INSERT', 0, 1, '2024-11-24 21:09:11.020'),
	(916, 24, 15, 1, 'INSERT', 0, 1, '2024-11-24 21:09:11.020'),
    (917, 24, 2, 1, 'REMOVE', NULL, 0, '2024-11-24 21:09:11.033'),
	(918, 24, 4, 1, 'REMOVE', NULL, 0, '2024-11-24 21:09:11.033'),
	(919, 24, 15, 1, 'REMOVE', NULL, 0, '2024-11-24 21:09:11.033');
5 rows affected

INSERT INTO ron_UserRights_Log (idDenyRight , strUserID, strRight, strRole, strEvent, old_bDeleted,new_bDeleted,ts) 
VALUES
	(760, 27, 12, 1, 'INSERT', 0, 1, '2024-11-24 21:11:37.140'),
	(920, 27, 9, 1, 'REMOVE', NULL, 1, '2024-11-24 21:11:37.140'),
	(921, 27, 12, 1, 'REMOVE', NULL, 0, '2024-11-24 21:11:37.140');
3 rows affected

INSERT INTO ron_UserRights_Log (idDenyRight , strUserID, strRight, strRole, strEvent, old_bDeleted,new_bDeleted,ts) 
VALUES
	(917, 24, 2, 1, 'INSERT', 0, 1, '2024-11-25 09:34:49.600'),
	(918, 24, 4, 1, 'INSERT', 0, 1, '2024-11-25 09:34:49.613'),
	(919, 24, 15, 1, 'INSERT', 0, 0, '2024-11-25 09:34:49.613'),
	(922, 24, 4, 1, 'REMOVE', NULL, 0, '2024-11-25 09:34:49.630'),
	(923, 24, 15, 1, 'REMOVE', NULL, 0, '2024-11-25 09:34:49.630');
5 rows affected

INSERT INTO ron_UserRights_Log (idDenyRight , strUserID, strRight, strRole, strEvent, old_bDeleted,new_bDeleted,ts) 
VALUES
	(924, 27, 5, 2, 'REMOVE', NULL, 0, '2024-11-26 01:11:37.140'),
	(925, 27, 8, 2, 'REMOVE', NULL, 0, '2024-11-26 01:11:37.140'),
	(926, 27, 10, 2, 'REMOVE', NULL, 0, '2024-11-26 01:11:37.140');
3 rows affected

SELECT * FROM ron_UserRights_Log


event_id
idDenyRight
strUserID
strRight
strRole
strEvent
old_bDeleted
new_bDeleted
ts


1
915
24
4
1
INSERT
0
1
2024-11-24 21:09:11.020

2
916
24
15
1
INSERT
0
1
2024-11-24 21:09:11.020

3
917
24
2
1
REMOVE
null
0
2024-11-24 21:09:11.033

4
918
24
4
1
REMOVE
null
0
2024-11-24 21:09:11.033

5
919
24
15
1
REMOVE
null
0
2024-11-24 21:09:11.033

6
760
27
12
1
INSERT
0
1
2024-11-24 21:11:37.140

7
920
27
9
1
REMOVE
null
1
2024-11-24 21:11:37.140

8
921
27
12
1
REMOVE
null
0
2024-11-24 21:11:37.140

9
917
24
2
1
INSERT
0
1
2024-11-25 09:34:49.600

10
918
24
4
1
INSERT
0
1
2024-11-25 09:34:49.613

11
919
24
15
1
INSERT
0
0
2024-11-25 09:34:49.613

12
922
24
4
1
REMOVE
null
0
2024-11-25 09:34:49.630

13
923
24
15
1
REMOVE
null
0
2024-11-25 09:34:49.630

14
924
27
5
2
REMOVE
null
0
2024-11-26 01:11:37.140

15
925
27
8
2
REMOVE
null
0
2024-11-26 01:11:37.140

16
926
27
10
2
REMOVE
null
0
2024-11-26 01:11:37.140

event_id	idDenyRight	strUserID	strRight	strRole	strEvent	old_bDeleted	new_bDeleted	ts
1	915	24	4	1	INSERT	0	1	2024-11-24 21:09:11.020
2	916	24	15	1	INSERT	0	1	2024-11-24 21:09:11.020
3	917	24	2	1	REMOVE	null	0	2024-11-24 21:09:11.033
4	918	24	4	1	REMOVE	null	0	2024-11-24 21:09:11.033
5	919	24	15	1	REMOVE	null	0	2024-11-24 21:09:11.033
6	760	27	12	1	INSERT	0	1	2024-11-24 21:11:37.140
7	920	27	9	1	REMOVE	null	1	2024-11-24 21:11:37.140
8	921	27	12	1	REMOVE	null	0	2024-11-24 21:11:37.140
9	917	24	2	1	INSERT	0	1	2024-11-25 09:34:49.600
10	918	24	4	1	INSERT	0	1	2024-11-25 09:34:49.613
11	919	24	15	1	INSERT	0	0	2024-11-25 09:34:49.613
12	922	24	4	1	REMOVE	null	0	2024-11-25 09:34:49.630
13	923	24	15	1	REMOVE	null	0	2024-11-25 09:34:49.630
14	924	27	5	2	REMOVE	null	0	2024-11-26 01:11:37.140
15	925	27	8	2	REMOVE	null	0	2024-11-26 01:11:37.140
16	926	27	10	2	REMOVE	null	0	2024-11-26 01:11:37.140