MS SQL Select and Count question

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   i'm not sure this is doable....ought to be.

i have a rows in a table with a Employee field (text),  Department (text) field  and a  Employee_Sig_Received (Bit) Field, among others, in it.  Department will be in each row and can be duplicated.

I want to put out a web page with Department (distinct) and how many 1's and how many 0's for the department.

Dept.    True    False
A             6         2
B             9         0
C             4         4

i've tried multiple combos of selects, goups, sums et all.  any ideas as to what would be needed.