cs_overviewactivityreportrecords_get.prc

community server 源码

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cs_OverviewActivityReportRecords_Get]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_OverviewActivityReportRecords_Get]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE PROC dbo.cs_OverviewActivityReportRecords_Get
(
	@BegReportDate datetime,
	@EndReportDate datetime
)

AS

/* # of new users in given time period */
SELECT COUNT(*) FROM aspnet_Membership
WHERE CreateDate BETWEEN @BegReportDate AND @EndReportDate


/* # of new threads in a given time period */
SELECT COUNT(*)
FROM cs_Threads
WHERE ThreadDate BETWEEN @BegReportDate AND @EndReportDate


/* # of new posts in a given time period */
SELECT COUNT(*)
FROM cs_Posts
WHERE PostDate BETWEEN @BegReportDate AND @EndReportDate



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

grant execute on [dbo].[cs_OverviewActivityReportRecords_Get] to public
go