fnFundRaiserHasAthonDonations

            create function [dbo].[fnFundRaiserHasAthonDonations]
            (    
            @FundRaiserID int
            )
            returns bit
            as
            begin
                return
                (
                select case count(frd.id) when 0 then 0 else 1 end
                from dbo.FundRaiserDonations frd
                inner join dbo.FundRaiserSolicitors frs on frs.ID = frd.SolicitorID
                where frs.RootFundRaiserID = @FundRaiserID and frd.IsAthon = 1
                )
            end