Count on different columns 1

[berkshirea]

hi guys, i've got a table like this, where col1 to col3 are checkboxes, it's either ticked or unticked.

id - item - col1 - col2 - col3
1 - david -checked - unchecked - checked
2 - david -checked - checked - unchecked
3 - anne -unchecked -checked - checked
4 - peter -checked - checked - unchecked
5 - peter -unchecked - unchecked - unchecked
.
..


and i want to have the recordset something like this(counting those with ticks on checkbox):

item - col1 - col2 - col3
david - 2 - 1 - 1
anne - 0 - 1 - 1
peter - 1 - 1 - 0

any tips guys? thanks in advance.

 

[markros]

select Item, 
sum(cast(col1 as int)) as Col1,
sum(cast(col2 as int)) as Col2,
sum(cast(col3 as int)) as Col3
from myTable group by Item

PluralSight Learning Library

 

[berkshirea]

thanks very much markros, it worked like a charm!!!

have a nice day!