USP_KPI_BBNC_NUMBEROFPAGEHITS

Parameters

Parameter	Parameter Type	Mode
@VALUE	int	INOUT
@ASOFDATE	datetime	IN
@DATEFILTER	tinyint	IN
@PAGEID	int	IN
Definition

Copy


                    CREATE procedure dbo.USP_KPI_BBNC_NUMBEROFPAGEHITS
                        @VALUE int output,
                        @ASOFDATE datetime, 
                        @DATEFILTER tinyint = null,
                        @PAGEID int = null
                    as

                        set nocount on;

                        if @DATEFILTER is null begin
                            set @DATEFILTER = 10;  -- all dates;

                        end

                        declare @STARTDATE datetime;
                        declare @ENDDATE datetime;

                        exec dbo.USP_RESOLVEDATEFILTER @DATEFILTER=@DATEFILTER, @STARTDATE=@STARTDATE output, @ENDDATE=@ENDDATE output, @ASOFDATE=@ASOFDATE;

                        if @PAGEID is null begin
                            select 
                                @VALUE = count(NETCOMMUNITYWEBTRAFFIC.ID)
                            from
                                dbo.NETCOMMUNITYWEBTRAFFIC
                            where
                                REQUESTDATE between @STARTDATE and @ENDDATE
                        end else begin
                            select 
                                @VALUE = count(NETCOMMUNITYWEBTRAFFIC.ID)
                            from
                                dbo.NETCOMMUNITYWEBTRAFFIC
                            where
                                PAGEID = @PAGEID
                                and REQUESTDATE between @STARTDATE and @ENDDATE
                        end

                        if @VALUE is null begin
                            set @VALUE = 0;
                        end