spStats_VisitCount

Parameters

Parameter	Parameter Type	Mode	Description
@BeginDate	datetime	IN
@EndDate	datetime	IN

Definition

Copy



            CREATE  PROCEDURE dbo.spStats_VisitCount
            (
            @BeginDate datetime,
            @EndDate datetime
            )
            AS
            BEGIN
                set nocount on

                DECLARE @Visits INT
                SELECT @Visits = SUM(Visits) 
                FROM StatisticsDaySite
                WHERE 
                YYYYMMDD >= convert(nchar(8),@BeginDate,112) AND 
                YYYYMMDD <= convert(nchar(8),@EndDate,112)
                SELECT @Visits Visits
            END