Posted by unabogie on 09/18/06 23:19

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.

• Next in forum: Looping a stored procedure in a dts package
• Prev in forum: Re: Using a trigger to generate an ID value
• Thread view: How To Select a Certain Limited Number of Rows Per ID

[Reply to this message]