EA7_spHandleDeletedEERecord

            CREATE   PROCEDURE [dbo].[EA7_spHandleDeletedEERecord]
            (
                @ClientUsersID    int
            )
            AS
            BEGIN
            set nocount on
            begin transaction

                UPDATE dbo.BackOfficeSystemUsers
                SET [current] = 0
                FROM dbo.BackOfficeSystemUsers bosu
                INNER JOIN dbo.BackOfficeSystemPeople bosp on bosp.id = bosu.BackOfficePeopleID 
                and bosp.BackOfficeSystemID = 1
                and bosu.ClientUsersID = @ClientUsersID
                and bosu.[current] = 1

            commit
            END