fnFundRaiserPageHits

            create function dbo.fnFundRaiserPageHits
            (    
            @SolicitorID int
            )
            returns int
            as
            begin
                Declare @PageID int
                Declare @Hits int

                select @PageID = sitepageid 
                from dbo.Fundraiserpages 
                where id = dbo.fnFundRaiserPageID(@SolicitorID,1)

                Select @Hits = Count(StatsID) 
                from dbo.Stats 
                where pageid = @PageID and frsolicitorId = @SolicitorID

                return @Hits
            end