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