spStats_PageHitsByFundRaiserID

CREATE    PROCEDURE dbo.spStats_PageHitsByFundRaiserID(@FundRaiserID int)
AS
BEGIN
    Declare @TotalCount int
    Declare @SolCount int
    Declare @SolMaxDate datetime
    Declare @TeamCount int
    Declare @TeamMaxDate datetime    

    SELECT
    @SolCount = Count(Stats.StatsID),
    @SolMaxDate = Max(Stats.RequestDate)
    FROM 
    dbo.Stats
    inner join dbo.fnFundRaiserSolicitorsAll(@FundRaiserID) Solicitor on Solicitor.ID = Stats.FRSolicitorID and Solicitor.SitePageID = Stats.PageID


    SELECT
    @TeamCount = Count(Stats.StatsID),
    @TeamMaxDate = Max(Stats.RequestDate)
    FROM 
    dbo.Stats
    inner join dbo.fnFundRaiserTeamsAll(@FundRaiserID) Team on Team.ID = Stats.FRTeamID and Team.SitePageID = Stats.PageID

    Set @TotalCount = @SolCount + @TeamCount

    Select 
    @TotalCount 'TotalVisits', 
    @SolMaxDate 'SolicitorDateLastVisited',
    @TeamMaxDate 'TeamDateLastVisited',
    @SolCount 'SolicitorsVisits',
    @TeamCount 'TeamsVisits'

END