spStats_PageViewsByPageID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PageId | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spStats_PageViewsByPageID]
(
@PageId int
)
AS
BEGIN
set nocount on
DECLARE @PageViews int
declare @YYYYMM nvarchar(7)
set @YYYYMM = (CONVERT(nchar(6),getutcdate(),112)+'%')
SELECT @PageViews = SUM(smp.PageViews)
FROM [dbo].[StatisticsMonthPage] smp
WHERE PageID = @PageID
SELECT @PageViews = @PageViews + SUM(sdp.PageViews)
FROM [dbo].[StatisticsDayPage] sdp
WHERE PageID = @PageID
AND sdp.YYYYMMDD LIKE @YYYYMM
SELECT @PageViews [PageViews]
END