Re: [Emerald] deactivating many subaccounts

Dale E. Reed Jr. ( (no email) )
Sun, 16 May 1999 19:47:51 -0700

Josh Hillman wrote:
> What SQL script would I use to deactivate (set all services
> that are associated with MBRs that have already been deactivated
> ( I know conceptually how to do this, but don't know the
> correct syntax for it when dealing with "update"... I already know that
> marking the MBR inactive prevents invoicing, authentication, etc.

Update sa
Set sa.Active = 0