IF NOT EXISTS(
SELECT a.ElectionID, a.GroupID, a.MaxChoices, Count(b.ElectionID) as AlreadyVotedCount
FROM
ElectionGroups a LEFT OUTER JOIN Votes b ON (( a.ElectionID = b.ElectionID) AND (a.GroupID = b.GroupID) )
WHERE
(a.LanguageID = @LanguageID) AND
(b.VoteByUser = @UserName)
GROUP BY
a.ElectionID, a.GroupID, a.MaxChoices
HAVING
(Count(b.ElectionID) < a.MaxChoices)
) AND EXISTS
(
SELECT ElectionID FROM Votes
WHERE
(ElectionID = @ElectionID) AND (VoteByUser = @UserName)
)
BEGIN
SET @Result = 0
SET @Reason = dbo.GetResourceString('ALREADY_VOTED_ALL', @LanguageID, @ElectionID)
END
puuuuh kutstage
