Undeliverable: Re: SQL Script

System Administrator ( postmaster@nmt.co.il )
Fri, 18 Sep 1998 23:51:01 +0200

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------ =_NextPart_000_01BDE34E.6CF11E9C
Content-Type: text/plain

Your message

To: greg@isat.com
Cc: emerald@iea-software.com
Subject: Re: SQL Script
Sent: Fri, 18 Sep 1998 23:32:02 +0200

did not reach the following recipient(s):

Emerald-list@mail.extent.com on Fri, 18 Sep 1998 23:50:54 +0200
The recipient name is not recognized
MSEXCH:IMS:NMT:nmt:MAIN 0 (000C05A6) Unknown Recipient

------ =_NextPart_000_01BDE34E.6CF11E9C
Content-Type: message/rfc822

Message-ID: <3602D152.9C11D90E@iea-software.com>
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: greg@isat.com
Cc: emerald@iea-software.com
Subject: Re: SQL Script
Date: Fri, 18 Sep 1998 23:32:02 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.1960.3)
Content-Type: text/plain

Greg Lowthian wrote:
> Dale can you send me the script to delete call records for
> users that have been removed from Emerald. I have written one
> but I'm not brave enough (or stupid enough) to run it and want
> to check it against yours.

It would be something like this:

Delete From Calls
Where Not Exists(
Select AccountID From SubAccounts
Where (Username = Login or Username = Shell or Username = email)

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

------ =_NextPart_000_01BDE34E.6CF11E9C--