How To Select a Certain Limited Number of Rows Per ID?

microsoft.public.sqlserver.programming

19 Sep 2006 12:46 AM

unabogie

I have a table with entries tied to a membership database. The problem
is that I want to select a limit of sixteen entries per member, per
day, where some members have 16+ entries per day.

I have this so far ( which I've simplified for this post)

SELECT    dbo.members.firstname, dbo.members.lastname,
dbo.entries.gameDay
FROM         dbo.members INNER JOIN
                      dbo.entries ON dbo.members.memberID =
dbo.entries.memberID

If it's day 5, each member should have 80 total.

How can I change this to select only 16 entries for each member, making
sure it's 16 per day based on dbo.entries.gameDay?

Thanks for your help.