fnAddressBookContactByConstitID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@ClientUsersID	int	IN
@ConstitID	int	IN

Definition

Copy



    CREATE FUNCTION dbo.fnAddressBookContactByConstitID
    (    
    @ClientUsersID int,
    @ConstitID int
    )
    RETURNS int
    AS
    BEGIN
        RETURN (SELECT [ID] 
        FROM dbo.AddressBookContacts 
        WHERE [ClientUsersID]=@ClientUsersID
        AND isnull([REID],0) = @ConstitID)
    END