fnFundRaiserSolicitorIDByBackOfficeID

        CREATE FUNCTION [dbo].[fnFundRaiserSolicitorIDByBackOfficeID]
        (
        @BackOfficeID int,
        @FRID int
        )
        RETURNS int
        AS
        BEGIN
            RETURN (SELECT frs.[ID] FROM [dbo].[FundRaiserSolicitors] frs
            INNER JOIN dbo.ClientUsers cu on frs.[BackOfficeID]=@BackOfficeID and frs.ClientUsersID = cu.ID and cu.Deleted = 0
            WHERE RootFundraiserID = @FRID)
        END