fnStats_PageHitsByFRTeamID

Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@TeamID	int	IN
@SitePageID	int	IN
Definition

Copy


        CREATE function [dbo].[fnStats_PageHitsByFRTeamID](@TeamID int, @SitePageID int) 
        RETURNS @PageHits TABLE 
        (
            NumVisits int,
            DateLastVisited datetime
        ) AS

        BEGIN 
        declare @temp TABLE (NumVisits int, DateLastVisited datetime)

        if (@SitePageID=0)
            begin
                insert into @temp (NumVisits, DateLastVisited) 
                select count(*) NumVisits,
                max(s.RequestDate) DateLastVisited
                from dbo.Stats s
                where s.FRTeamID=@TeamID
            end    
        else
            begin
                insert into @temp (NumVisits, DateLastVisited) 
                select count(*) NumVisits,
                max(s.RequestDate) DateLastVisited
                from dbo.Stats s
                where s.FRTeamID=@TeamID
                and (s.PageID = @SitePageID)
            end
        insert @PageHits (NumVisits, DateLastVisited) select NumVisits, DateLastVisited from @temp
        return 
        END