spStats_TotalPageViews

CREATE PROCEDURE [dbo].[spStats_TotalPageViews]
AS
BEGIN
    set nocount on

    DECLARE @PageViews int

    SELECT @PageViews = SUM(smp.PageViews)
    FROM [dbo].[StatisticsMonthPage] smp

    SELECT @PageViews = @PageViews + isnull(SUM(sdp.PageViews),0)
    FROM [dbo].[StatisticsDayPage] sdp 
    WHERE sdp.YYYYMMDD LIKE CONVERT(nchar(6),getutcdate(),112)+'%'

    SELECT @PageViews [PageViews]
END