spFindByEmail_AddressBookContacts

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ClientUsersID	int	IN
@EmailAddress	nvarchar(100)	IN
@FirstName	nvarchar(100)	IN
@LastName	nvarchar(100)	IN
@OrgName	nvarchar(60)	IN

Definition

Copy


            CREATE   PROCEDURE [dbo].[spFindByEmail_AddressBookContacts]
                (
                @PKID int output,
                @ClientUsersID int,
                @EmailAddress nvarchar(100),
                @FirstName nvarchar(100),
                @LastName nvarchar(100),
                @OrgName nvarchar(60)
                )
            AS
                Select @PKID = AddressBookContacts.[ID] 
                FROM AddressBookContacts 
                WHERE 
                [ClientUsersID] = @ClientUsersID AND 
                isnull([Email], '') = @EmailAddress AND
                isnull([FirstName], '') = @FirstName AND
                isnull([LastName], '') = @LastName AND
                isnull([OrgName], '') = @OrgName