SQL SERVER – Fix: Error: 8117: Operand data type bit is invalid for sum operator

(Pinal Dave) Here is the very interesting error I received from a reader. He has very interesting question. He attempted to use BIT filed in the SUM aggregation function and he got following error. He went ahead with various different datatype (i.e. INT, TINYINT etc) and he was able to do the SUM bu

Read More - Register for Free Membership