fnFundRaiserSolicitorIDByClientUserID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@FundRaiserID	int	IN
@ClientUserID	int	IN

Definition

Copy



            CREATE   FUNCTION [dbo].[fnFundRaiserSolicitorIDByClientUserID]
            (
            @FundRaiserID int,
            @ClientUserID int
            )
            RETURNS int
            AS
            BEGIN
            RETURN (SELECT DISTINCT [ID] FROM dbo.FundRaiserSolicitors
            WHERE [ClientUsersID]=@ClientUserID and RootFundRaiserID = @FundRaiserID)
            END