> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Ronnie D. Franklin
> Sent: Monday, July 26, 1999 8:03 PM
> To: emerald@iea-software.com
> Subject: RE: [Emerald] Closed Accounts
>
>
> I would like to take this senario one step futher.....
>
> I would like to have a script that would change all MBR's that are over 30
> days expired, including Temporary Extend and Permanent Extend, to Active =
> 0, and also void any outstanding invoices for that account.
>
> > > Any ideas of how others are handling this would be helpful.
> >
> > Hmmm lets see:
> >
> > Update MasterAccounts
> > Set Active = 0
> > Where PayMethod = 'Other'
> > and BilledThru < GetDate()
> >
> >
> > You could just schedule that with SQL Executive/Agent say once a week or
> > once a night.
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart