Re: SQL Script

Dale E. Reed Jr. ( (no email) )
Fri, 18 Sep 1998 14:32:02 -0700

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