WITH Winners(GameID, PlayerNick) AS( SELECT g.GameID, w.PlayerNick FROM dbo.Games AS g CROSS APPLY fGameWinner(g.GameID) AS w WHERE g.GameID IN ( SELECT g.GameID FROM Games AS g INNER JOIN GameEntries AS ge1 ON ge1.GameID = g.GameID INNER JOIN GameEntries AS ge2 ON ge2.GameID = g.GameID INNER JOIN vPlayerPerGame AS ppg ON ppg.GameID = g.GameID WHERE ge1.PlayerNick = 'Jostein' AND ge2.PlayerNick = 'tavi' AND ppg.Players = 2 ))SELECT PlayerNick, COUNT(GameID) AS 'Wins' FROM Winners GROUP BY PlayerNick-- RESULTSJostein 33tavi 36