Hi,

I'm trying to create a set of months for which a blogger has written an entry plus the number of entries for each month.

So I believe I need to group by month and year of a date field and then count the posts.

How do I go about doing this with LLBLGen?

Cheers, Ian.

Or this....

ALTER PROCEDURE [dbo].[sp_GetBlogEntryDates]

    @bloggerID int

AS
BEGIN

SELECT
    Datepart("month", Date) as "Month",
    Datepart("yy", Date) as "Year",
    count(*) as "Count"

FROM
    tbl_BlogEntry

WHERE
    BloggerID = @bloggerID
    AND
    Live = 1

GROUP BY
    Datepart("yy", Date), Datepart("month", Date)

ORDER BY
    Year DESC, Month DESC

Hi,

please read the following thread for how to handle "month" and "year" in your predicates:

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3829

Ok thanks.