Posted by masri999 on 09/19/06 09:48

Hello,

Post Table Schema and Sample entries in your table

M A Srinivas

unabogie@gmail.com wrote:
> 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: Why cannot set Unicode string
• Prev in forum: Looping a stored procedure in a dts package
• Thread view: Re: How To Select a Certain Limited Number of Rows Per ID

[Reply to this message]