spStats_VisitSummary

CREATE PROCEDURE [dbo].[spStats_VisitSummary]
    (
    @BeginDate datetime,
    @EndDate datetime
    )
    AS
    BEGIN

    set nocount on

    DECLARE @Visits int
    DECLARE @VisitsPerDay decimal(38,2)
    DECLARE @DaysinRange int
    DECLARE @SessionTime decimal(38,2)
    DECLARE @SessionLength decimal(38,2)

    select @Visits = SUM(Visits), @SessionTime = SUM(SessionTime)
    FROM StatisticsDaySite 
    WHERE YYYYMMDD >= CONVERT(nchar(8),@BeginDate,112)
    AND YYYYMMDD <= CONVERT(nchar(8),@EndDate,112)

    SET @DaysinRange = DATEDIFF(d,@BeginDate,@EndDate)
    If @DaysinRange > 0
        SET @VisitsPerDay = convert(decimal(38,2),@Visits)/convert(decimal,@DaysinRange)
    else
        SET @VisitsPerDay = @Visits

    if @Visits > 0 
        SET @SessionLength = (@SessionTime/@Visits)

    Select 
        @Visits 'Visits', 
        @DaysinRange 'DaysinRange', 
        @VisitsPerDay 'VisitsPerDay', 
        @SessionTime 'SessionTime', 
        @SessionLength 'SessionLength'

END