Re: Procedures

Michael Whisenant ( mwhisen@airnet.net )
Wed, 06 May 1998 10:34:36 -0500

Took me forever to figure out what was wrong with the script that you
provided. I naturally assumed that you would never include a typo :) hehehe

>
>A query like this would clean them out, but it might take a while to process:
>
>Delete
>From Calls
>Where CallDate < '4/1/98'
> And Not Exists
> ( Select AccountID
> From SubAccounts
> Where Calls.Usernmame = SubAccounts.Login
> Or Calls.Usernmame = SubAccounts.Shell
> Or Calls.Usernmame = SubAccounts.EMail
> )
Usernmame is not a valid column. It took me 4 hours to finally see that
extra m,
Michael J. Whisenant
Vice-President, Operations
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329