SQL Server“不能对包含聚合或子查询的表达式执行聚合函数”，但是Sybase可以

This issue has been discussed before, but none of the answers address my specific problem because I am dealing with different where clauses in the inner and outer selects. This query executed just fine under Sybase, but gives the error in the title of this post when executed under SQL Server. The query is complicated, but the general outline of the query is:This issue has been discussed before, but none