Lame SQL, Just Lame

We have a table with a bunch of columns that are of “bit” type. I want to count the number of bits flipped to 1 in those columns. Seems like that should be a fairly common use case, doesn’t it? Count won’t work because it gives me a count of all the records, not just the bits flipped to 1. SUM() function on these columns gives this error:

“Operand data type bit is invalid for sum operator.”

Seriously?! Again, lame.