How can I use SUM for bit columns?

sql sql-server tsql aggregate-functions

SELECT SUM(CAST(bitColumn AS INT))FROM dbo.MyTable

need to cast into number

or another solution -

SELECT COUNT(*)FROM dbo.MyTableWHERE bitColumn = 1

sql sql-server tsql aggregate-functions

You could consider 0 as nulls and simply count the remaining values:

SELECT count(nullif(bitColumn, 0))FROM MyTable;

sql sql-server tsql aggregate-functions

SELECT SUM(bitColumn * 1) FROM dbo.MyTable

Converts the bit into int, by multiplication, clean and simple

CodeHunter