spStats_Visits
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BeginDate | datetime | IN | |
| @EndDate | datetime | IN | |
| @byFormat | nchar | IN |
Definition
Copy
CREATE Procedure dbo.spStats_Visits
(
@BeginDate datetime,
@EndDate datetime,
@byFormat nchar(1)
)
AS
BEGIN
set nocount on
if @byFormat='m'
select convert(nchar(10), convert(datetime, YYYYMM+'01'),102) [datekey],
SUM(Visits) [Visits]
FROM dbo.StatisticsMonthSite
WHERE YYYYMM >= convert(nchar(6),@BeginDate,112)
AND YYYYMM <= convert(nchar(6),@EndDate,112)
GROUP BY convert(nchar(10), convert(datetime, YYYYMM+'01'),102)
else
select convert(nchar(10), convert(datetime, YYYYMMDD),102) [datekey],
SUM(Visits) [Visits]
FROM dbo.StatisticsDaySite
WHERE YYYYMMDD >= @BeginDate
AND YYYYMMDD <= @EndDate
GROUP BY convert(nchar(10), convert(datetime, YYYYMMDD),102)
END