fnStats_PageHitsByFRTeamIDAll

CREATE FUNCTION dbo.fnStats_PageHitsByFRTeamIDAll(@TeamID int)
RETURNS Int
AS

BEGIN

    DECLARE @SolicitorHits int
    DECLARE @TeamHits int

    SELECT @SolicitorHits = count(stats.statsid)
    FROM dbo.Stats
    INNER JOIN dbo.fnFundRaiserChildSolicitorsForTeam(@TeamID) Solicitor on stats.FRSolicitorID = Solicitor.ID AND Stats.PageID = Solicitor.SitePageID

    SELECT @TeamHits = count(stats.statsid)
    FROM dbo.Stats
    INNER JOIN dbo.fnFundRaiserChildTeamsForTeam(@TeamID) Team on Stats.FRTeamID = Team.TeamID AND Stats.PageID = Team.SitePageID

    RETURN ISNULL(@SolicitorHits,0) + ISNULL(@TeamHits,0)


END