Error:An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/4f451388-8239-4042-b0f7-2d7b3bc1aca1/