cs_weblog_postsbymonth.prc

解压即可使用

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

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


CREATE proc [dbo].cs_weblog_PostsByMonth
(
	@SectionID int,
	@Year int,
	@Month int
)
as

SET Transaction Isolation Level Read UNCOMMITTED


Select @Month as [Month], @Year as [Year], Day(b.BloggerTime) as [Day], Count(*) as [Count] 
From cs_weblog_Posts b, cs_Posts p
where b.PostID = p.PostID and p.SectionID = @SectionID and p.IsApproved = 1 and b.BlogPostType = 1 and p.PostLevel = 1 and Month(b.BloggerTime) = @Month and Year(b.BloggerTime) = @Year and P.PostDate <= getdate()
Group by Day(b.BloggerTime) order by  [Day]




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

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