spDelete_AddressBookContacts_Assigned

Parameters

Parameter Parameter Type Mode Description
@ClientUsersID int IN

Definition

Copy


    CREATE PROCEDURE dbo.spDelete_AddressBookContacts_Assigned
    (
    @ClientUsersID int
    )
    AS 
    UPDATE dbo.AddressBookContacts SET [Deleted]=1 WHERE [ClientUsersID]=@ClientUsersID AND isnull([REID],0)>0