>Usually, when I have a GROUP clause, and the select for the fields has to include additional fields, I simply use the MAX() syntax to add more fields which are not part of the group. However, I now need to include a bit field. A MAX() is not supported on a bit field. What would be the best approach to obtain that field in the field list?
You can max(cast(bitfield as tinyint)) and perhaps even cast(max(cast(bitfield as tinyint)) as bit).