spGetAddressBookContacts

Parameters

Parameter Parameter Type Mode Description
@ClientUsersID int IN

Definition

Copy



CREATE PROCEDURE [dbo].[spGetAddressBookContacts]
    (
    @ClientUsersID int
    )
AS 
SELECT 
[ID],[ClientUsersId],[ClientData],[FirstName],[LastName],[OrgName],[Email],[REID],[EmailGreeting],[Deleted], [ContactGroupID]
FROM AddressBookContacts WHERE ClientUsersId = @ClientUsersID AND [DELETED] = 0