TOP returnerer forkert antal rækker

TOP(3) giver dig 3 rækker - hvis der er 3 eller flere.
Så dit sub-select giver dig ikke altid 3 rækker.

Her er et forsøg på at løse dit problem på en anden måde:

SELECT MIN(TeamType) as TeamType, MIN(CupId) as CupId, MIN(TeamId) as TeamId, MIN(EventTypeLinkId) as EventTypeLinkId, MIN(S1.Id) as Id, SUM(Point) as Point, SUM(OverallPoint) as OverallPoint
from (
SELECT s1.*, row_nuber() over(partition by s1.TeamId order by s1.Point desc) Nr
FROM EventParticipatingTeams S1, EventTypeLinks
WHERE S1.EventTypeLinkId = EventTypeLinks.Id
AND CupId = @cupID
AND EventTypeLinks.EventTypeId = @eventTypeId
AND TeamType = @teamType
AND Point > 0
) x
where Nr <= 3
GROUP BY S1.TeamId
ORDER BY Point DESC

I always believed that TOP X would return X or more rows but after looking around on google that doesn't seem to be the case.

If there are ties in the result then you have to use WITH TIES to show these.

http://blog.sqlauthority.com/2009/12/23/sql-server-order-by-clause-and-top-with-ties/

SO a simple SELECT TOP X ORDER BY should give X in the result

select top 3 udenom vil måske også virke? Ellers er jeg enig med de 2 andre :)

Måske kunne OP komme med nogle eksempel data fra tabellerne, som kunne illustrere problemet? Helst med tilhørende tabelopbygning mv.

Jeg synes umiddelbart, at forespørgslen ser unødvendigt kompliceret ud til det jeg tror den skal lave. Men selv det er jeg i tvivl om, hvad er... :-)