fnFundRaiserSolicitorCount

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@FundRaiserID int IN

Definition

Copy


            create FUNCTION [dbo].[fnFundRaiserSolicitorCount](   

               @FundRaiserID int

            )

                RETURNS int

            AS

                BEGIN

                    RETURN (

                    SELECT

                        Count(ID)

                    FROM

                        dbo.FundRaiserSolicitors Solicitor

                        WHERE Solicitor.RootFundraiserID = @FundraiserID
                )

            END