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: