cs_weblog_postsbymonthlist.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_PostsByMonthList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_weblog_PostsByMonthList]
GO


CREATE proc [dbo].cs_weblog_PostsByMonthList
(
	@SectionID int
)
as

SET Transaction Isolation Level Read UNCOMMITTED

Select Month(b.BloggerTime) as [Month], Year(b.BloggerTime) as [Year], 1 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
Group by Year(b.BloggerTime), Month(b.BloggerTime) order by [Year] desc, [Month] desc




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

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