spStats_PageHitsByFundRaiserTeamID

CREATE   PROCEDURE dbo.spStats_PageHitsByFundRaiserTeamID(@FundRaiserTeamID int)
AS
BEGIN

    --Fundraiser Page hits FOR TEAM
    --Solicitor and Team

    declare @SolicitorHits int
    declare @SolicitorLastVisit datetime
    declare @TeamHits int
    declare @TeamLastVisit datetime


    SELECT 
    @SolicitorHits = count(*),
    @SolicitorLastVisit = Max(s.RequestDate)
    from dbo.Stats s
    inner join dbo.fnFundRaiserChildSolicitorsForTeam(@FundRaiserTeamID) Solicitor ON Solicitor.ID = s.FRSolicitorID AND Solicitor.SitePageID = s.pageid

    SELECT
    @TeamHits = count(*),
    @TeamLastVisit = Max(s.RequestDate)
    from dbo.Stats s
    inner join dbo.fnFundRaiserChildTeamsForTeam(@FundRaiserTeamID) Team ON Team.TeamID = s.FRTeamID AND Team.SitePageID = s.pageid

    SELECT
    @SolicitorHits 'SolicitorsVisits', 
    @TeamHits 'TeamsVisits', 
    @TeamHits + @SolicitorHits 'NumVisits',
    @SolicitorLastVisit 'SolicitorsLastDate',
    @TeamLastVisit 'TeamsLastDate'

END