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 sa.active=0) all services
> that are associated with MBRs that have already been deactivated
> (ma.active=0)? 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