fnStats_PageHitsByFRSolicitorID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SolicitorID	int	IN
@SitePageID	int	IN

Definition

Copy



            CREATE    function [dbo].[fnStats_PageHitsByFRSolicitorID](@SolicitorID int, @SitePageID int) returns table
            as
            return (
            select top 100 percent
            s.UserPersonalPageID,
            count(*) NumVisits,
            max(s.RequestDate) DateLastVisited
            from dbo.Stats s
            inner join dbo.UserPersonalPages upp on upp.ID=s.UserPersonalPageID
            --inner join dbo.FundRaiserPages frp on frp.ID=upp.FundRaiserPageID
            where s.FRSolicitorID=@SolicitorID
            and upp.ParentID=@SolicitorID
            and (@SitePageID=0 or s.PageID=@SitePageID)
            group by s.UserPersonalPageID
            order by NumVisits desc
            )