SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE example (
  id   INT,
  v1   INT,   i1   INT,   t1   INT,
  v2   INT,   i2   INT,   t2   INT,
  v3   INT,   i3   INT,   t3   INT,
  v4   INT,   i4   INT,   t4   INT
)
INSERT INTO
  example
VALUES
  (1,    15,    1,    1,      12,    1,    1,      22,    1,    3,    NULL, NULL, NULL),
  (2,    15,    1,    1,      22,    2,    3,    NULL, NULL, NULL,      16,    1,    1),
  (3,    15,    1,    1,      15,    2,    1,    NULL, NULL, NULL,    NULL, NULL, NULL),
  (4,  NULL, NULL, NULL,    NULL, NULL, NULL,      18,    2,    1,    NULL, NULL, NULL)
4 rows affected

SELECT
  id,
  CASE WHEN t1=1 AND i1=min_i THEN v1 ELSE 0 END
  +
  CASE WHEN t2=1 AND i2=min_i THEN v2 ELSE 0 END
  +
  CASE WHEN t3=1 AND i3=min_i THEN v3 ELSE 0 END
  +
  CASE WHEN t4=1 AND i4=min_i THEN v4 ELSE 0 END
FROM
  example
OUTER APPLY
(
  SELECT
    MIN(i1)  AS min_i
  FROM
  (
    SELECT i1 WHERE t1=1
    UNION ALL
    SELECT i2 WHERE t2=1
    UNION ALL
    SELECT i3 WHERE t3=1
    UNION ALL
    SELECT i4 WHERE t4=1
  )
    AS pvt
)
  AS indicator_check


id
(No column name)


1
27

2
31

3
15

4
18