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