Get some rest! We need you rested a tad, and working on Emerald 2.5. But
I tried this script and got another error message.
Msg 144, Level 15, State 1
Cannot use an aggregate or a subquery in an expression used for the by-list
of a GROUP BY clause.
At 04:42 PM 5/25/98 -0700, you wrote:
>Michael A. Davis Jr. wrote:
>>
>> Dale, I pasted your script in and ran it, but I got the following errors
>> back...
>
>Sorry. I must have been working to hard. :(
>
>Select DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
>From Calls
>Group By DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
>Order By DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
>
>--
>Dale E. Reed Jr. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
Michael J. Whisenant
Vice-President, Operations
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329