SQL Server7中不能对布尔型字段进行分组汇总?

Question

假设field4为boolean型field2和field3为可求和的字段
select a.field1,num=sum(a.field2),num2=sum(a.field3)
from(select field1,field2,field3,aa=convert(char,field4) from tablename) a
group by a.aa
有这个例子想信你的问题就解决了

Answer 1

你可以先把bit字段转化为字符
例如:
----------------------------------------------------------------
假设field4为boolean型field2和field3为可求和的字段
-----------------------------------------------------------------
select field1,num=sum(a.field2),num2=sum(a.field3),aa
from
(select field1,field2,field3,aa=case field4 when 0 then '0' else '1' end
 from tablename) a
group by field1,aa

Answer 2

补充:
SQL Server7中不能对布尔型字段进行分组汇总