sql server mseq: Hi,
I'm getting the following error:
cannot perform aggregate function on an expression
containing aggregate function or subquery.
In my query I am using sum() on a subquery.
I wanna ask if is there an option in ODBC or in SQL
Server to let me use an aggregate function on a subquery
or I have to re-structure my query in another way.

Fady,

Can you post DDL/some sample records and required output.

--
- Vishal