SQL Server 2019

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

CREATE TABLE SystemProblems (
  BuildId int primary key not null,
  Error1 bit,
  Error2 bit,
  Error3 bit,
  Error4 bit,
  Warning1 bit,
  Warning2 bit,
  Warning3 bit,
  Warning4 bit
)

insert into SystemProblems values
(1, 1, 0, 0, 0, 1, 1, 0, 1),
(2, 0, 1, 0, 1, 0, 0, 1, 0),
(3, 0, 0, 0, 0, 0, 0, 0, 0);
3 rows affected

SELECT *
FROM SystemProblems;


BuildId
Error1
Error2
Error3
Error4
Warning1
Warning2
Warning3
Warning4


1
True
False
False
False
True
True
False
True

2
False
True
False
True
False
False
True
False

3
False
False
False
False
False
False
False
False


SELECT SP.BuildId,
       SUM(CASE WHEN Errors = 1 THEN 1 ELSE 0 END) ErrorsSum,
       SUM(CASE WHEN Warnings = 1 THEN 1 ELSE 0 END) WarningsSum
FROM SystemProblems SP
CROSS APPLY
(
  VALUES
  (Error1, Warning1),
  (Error2, Warning2),
  (Error3, Warning3),
  (Error4, Warning4)
) T(Errors, Warnings)
GROUP BY SP.BuildId;


BuildId
ErrorsSum
WarningsSum


1
1
3

2
2
1

3
0
0

BuildId	Error1	Error2	Error3	Error4	Warning1	Warning2	Warning3	Warning4
1	True	False	False	False	True	True	False	True
2	False	True	False	True	False	False	True	False
3	False	False	False	False	False	False	False	False