also please see the attached schema's example,

regards,

Shumail

[font="Verdana"]below is the short example and i am facing error on having clause,

Server: Msg 8124, Level 16, State 1, Line 3

Multiple columns are specified in an aggregated expression containing an...