fnFundRaiserHasChangeBuckets

            CREATE FUNCTION [dbo].[fnFundRaiserHasChangeBuckets]
            (
            @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.IsChangeBucket = 1
            )
            end