SQL Server 2017

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

CREATE TABLE t (ID int, TYPE int);
INSERT INTO t(ID, TYPE) VALUES
(40208001, 700),
(40208001, 1100),
(40209017, 900),
(40209017, 800),
(40209017, 910),
(40209017, 1200),
(40210494, 1100),
(40210494, 1000),
(40210494, 1200),
(40210551, 400),
(40210551, 1200),
(40210767, 1200),
(40210767, 800),
(40211724, 1300),
(40211724, 900),
(40211724, 500)
16 rows affected

SELECT ID, CASE
    WHEN TYPE IN (1000, 1100, 1200, 1300) AND hasother = 'y' THEN NULL
    ELSE TYPE
END AS TYPE
FROM t
OUTER APPLY (
    SELECT TOP 1 'y'
    FROM t AS x
    WHERE ID = t.ID AND TYPE NOT IN (1000, 1100, 1200, 1300)
) OA(hasother)


ID
TYPE


40208001
700

40208001
null

40209017
900

40209017
800

40209017
910

40209017
null

40210494
1100

40210494
1000

40210494
1200

40210551
400

40210551
null

40210767
null

40210767
800

40211724
null

40211724
900

40211724
500


UPDATE t
SET TYPE = NULL
WHERE TYPE IN (1000, 1100, 1200, 1300)
AND EXISTS (
    SELECT 1
    FROM t AS x
    WHERE ID = t.ID
    AND TYPE NOT IN (1000, 1100, 1200, 1300)
)
5 rows affected

SELECT *
FROM t


ID
TYPE


40208001
700

40208001
null

40209017
900

40209017
800

40209017
910

40209017
null

40210494
1100

40210494
1000

40210494
1200

40210551
400

40210551
null

40210767
null

40210767
800

40211724
null

40211724
900

40211724
500

ID	TYPE
40208001	700
40208001	null
40209017	900
40209017	800
40209017	910
40209017	null
40210494	1100
40210494	1000
40210494	1200
40210551	400
40210551	null
40210767	null
40210767	800
40211724	null
40211724	900
40211724	500