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