>>But if you set the EngineBehavior to 70, it will allow you to group by the output column.
>
>Hi Dan,
>
>Changing the Enginebehavior value should be considered as band aid to stop the immediate bleeding, the best is to leave the setting at default, and change the select statements once and for all. You are in reality only pushing the problems in front of you, unless you will never use some 'real' SQL server as backend.

I agree.