spStats_PageViewSummary
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BeginDate | datetime | IN | |
| @EndDate | datetime | IN |
Definition
Copy
CREATE PROCEDURE dbo.spStats_PageViewSummary
(
@BeginDate datetime,
@EndDate datetime
)
AS
BEGIN
set nocount on
SELECT
SUM(Visits) 'Visits',
SUM(PageViews) 'PageViews'
FROM StatisticsDaySite
WHERE YYYYMMDD >= Convert(nchar(8), @BeginDate, 112)
AND YYYYMMDD <= Convert(nchar(8), @EndDate, 112)
END