User Profile

ssasser

Last Activity: Dec 26 '07, 10:17 PM

Joined: Dec 26 '07

Location:

ssasser replied to counting distinct posts by a users within the past 10 days - SQL2005

in SQL Server

Dec 26 '07, 10:13 PM

TRY THIS

Code:

SELECT     COUNT(PostAuthor) AS PM_Post_Count, PostAuthor
FROM         dbo.cs_Posts
WHERE     (PostDate = DATEADD(d, - 10, GETDATE())) OR
                      (PostAuthor = N'haley') OR
                      (PostAuthor = N'clapoint') OR
                      (PostAuthor = N'dclecompte')
GROUP BY PostAuthor

...

See more | Go to post

Leave a comment:

ssasser started a topic counting distinct posts by a users within the past 10 days - SQL2005

in SQL Server

Dec 26 '07, 08:58 PM
counting distinct posts by a users within the past 10 days - SQL2005

Hey gang, any help will be apprecited. I am trying to do a simple count of all posts to a message board from a few particular users within the past 10 days.

I know the usernames and number of days that i want to query (10) and I want the output to display as follows....
Manager PostCount
user1 1
user2 14
user3 20
_______________ ____

The...

See more | Go to post

No activity results to display

Profile Sidebar

Leave a comment:

counting distinct posts by a users within the past 10 days - SQL2005