"Carol Cox" <cgcox@inasolutions.com> wrote in message
news:uoqY9HUZDHA.4020@tk2msftngp13.phx.gbl...
>
> When I try to SUM a subquery I get an error that says "Cannot perform an
> aggregate function on an expression containing an aggregate or a
> subquery."
>
> For example:
>
> select sum(cast(
> select value
> from table2 t2
> where t2.column2 = t1.column2
> )as int) as Result
> from table t1
>
> Thanks for your help!
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!