>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?
If you don't care about the value of that field:
just add CAST(0 as bit) AS BitField in field list.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.