On Thursday, September 11, 2003, at 06:24 PM, Ian Skinner wrote: > your group by is on the wrong query. you need it on the sub-query > where the > max is at. > > Case > ( > Select MAX count(etp.etprocedureid) > from eTransferProtocolLink etp > Where etp.etProcedureid = et.etProcedureid and > etp.protocolid = 12 > GROUP BY etp.etprocedureid > ) >
I ran this. I received this error: Incorrect syntax near the keyword 'count'. Then I put parens around count() so it read Select Max(count(etp.etprocedureid)) Running that I received this error: Cannot perform an aggregate function on an expression containing an aggregate or a subquery. -Patti ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
