Re: SQL Commands

Dale E. Reed Jr. ( (no email) )
Tue, 26 May 1998 09:35:51 -0700

Michael Whisenant wrote:
>
> 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.

Ok. Now I really feel stupid. I guess thats what I get for not actually
trying it. You just need to remove the ", count(Calldate) from the end of
the Group by and Order By lines and it will work (and yes, I tested it this
time).

> >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