using a subquery in aggregate function

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.
Thanks

Fady,

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

--
- Vishal

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 23rd April 11:17 fady chammas External User Posts: 1	using a subquery in aggregate function 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. Thanks

2 23rd April 11:17 vishal parkar External User Posts: 1	using a subquery in aggregate function Fady, Can you post DDL/some sample records and required output. -- - Vishal