Re: QUERY HELP NEEDED

From: <fitzjarrell_at_cox.net>
Date: 12 Mar 2007 08:18:26 -0700
Message-ID: <1173712706.191085.107640@s48g2000cws.googlegroups.com>

On Mar 12, 12:41 am, "fwdk..._at_gmail.com" <fwdk..._at_gmail.com> wrote:
> Hi
> sorry for the late reply. One thing i forget to mention is that i am
> using MS SQL Server 2000 and when i use max(count(column_name)) it
> gives me error msg CANNOT PERFORM AN AGGREGATE FUNCTION ON AN
> EXPRESSION CONTAINING AN AGGREGATE OR A SUBQUERY and also there is no
> RANK() function available.

If you're using SQL Server why on EARTH are you posting this question HERE???
You SHOULD be posting in comp.databases.sql-server.

David Fitzjarrell Received on Mon Mar 12 2007 - 10:18:26 CDT