Msg 156, Level 15, State 1
Incorrect syntax near the keyword 'Select'.
Msg 156, Level 15, State 1
Incorrect syntax near the keyword 'Select'.
Any help would be appreciated. Thanks, Mike
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Monday, May 25, 1998 4:10 PM
Subject: Re: SQL Commands
>You can get a list of Calls records per month doing this:
>
>
>Select DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
>From Calls
>Group By Select DatePart(Year, CallDate), DatePart(Month, CallDate),
>Count(CallDate)
>Order By Select 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