SQL Server 2022

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

CREATE TABLE tab(
	ID 			INT,	
  	Value_ 		VARCHAR(30),
    Status_     VARCHAR(30)
);
INSERT INTO tab VALUES
(1, 	'AAA', 'Matched'),
(2, 	'BBB', 'Matched'),
(3, 	'CCC', 'Matched'),
(1, 	'AAA', 'Matched'),
(2, 	'BBB', 'Matched'),
(3, 	'CXX', 'Matched');

SELECT * FROM tab


ID
Value_
Status_


1
AAA
Matched

2
BBB
Matched

3
CCC
Matched

1
AAA
Matched

2
BBB
Matched

3
CXX
Matched


SELECT tab.*, 
	   CASE WHEN MIN(Value_) OVER(PARTITION BY ID)
               = MAX(Value_) OVER(PARTITION BY ID)
            THEN 'Matched'
            ELSE 'Not Matched'
       END AS Status_ 
FROM tab


ID
Value_
Status_
Status_


1
AAA
Matched
Matched

1
AAA
Matched
Matched

2
BBB
Matched
Matched

2
BBB
Matched
Matched

3
CCC
Matched
Not Matched

3
CXX
Matched
Not Matched


WITH cte AS ( 
    SELECT tab.*, 
	       CASE WHEN MIN(Value_) OVER(PARTITION BY ID)
                   = MAX(Value_) OVER(PARTITION BY ID)
                THEN 'Matched'
                ELSE 'Not Matched'
           END AS newStatus 
    FROM tab
)
UPDATE cte
SET Status_ = newStatus
WHERE NOT Status_ = newStatus; 

SELECT * FROM tab


ID
Value_
Status_


1
AAA
Matched

2
BBB
Matched

3
CCC
Not Matched

1
AAA
Matched

2
BBB
Matched

3
CXX
Not Matched

ID	Value_	Status_
1	AAA	Matched
2	BBB	Matched
3	CCC	Matched
1	AAA	Matched
2	BBB	Matched
3	CXX	Matched

ID	Value_	Status_
1	AAA	Matched
2	BBB	Matched
3	CCC	Not Matched
1	AAA	Matched
2	BBB	Matched
3	CXX	Not Matched