Message 2:
from "Blade" <blade@compuzone.net>
Message 3: RE:
from David Kerr <dkerr@phonet.com>
Message 4: Re: SQL Commands
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 5: RE: Serious Problem
from "Robert H. Clugston" <robert@csnsys.com>
Message 6: New Customer Info Sheet
from Carl Jagerski <carll@forcomm.net>
Message 7: Re: New Customer Info Sheet
from "Pat Augustine" <ereth@ilnk.com>
Message 8: Re: New Customer Info Sheet
from John Lange <radadmin@palacenet.net>
Message 9: Re: New Customer Info Sheet
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 10: RE: New Customer Info Sheet
from ronnie@itexas.net (Ronnie D. Franklin)
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: SQL Commands
From: Michael Whisenant <mwhisen@airnet.net>
Date: Tue, 26 May 1998 10:02:15 -0500
Dale,
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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject:
From: "Blade" <blade@compuzone.net>
Date: Tue, 26 May 1998 11:35:49 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_000C_01BD889A.6EAFD480
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am running Emerald 2.1 w/ SQL Server 6.5. I currently have two users =
showing up in my calls on-line dialog, even though my NAS has been =
restarted... RadiusNT (2.2) won't let these two locked in people connect =
now. I have concurrency control enforced. Does anyone know a way to =
clear the calls online table so these people can log in? Thanx in =
advance.
=20
CompuZone NET Administrator
blade@compuzone.net
=20
------=_NextPart_000_000C_01BD889A.6EAFD480
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">