I'd probably resort to a set-based loop.

DECLARE @ROWS INT = 0;

WHILE @ROWS = 0

BEGIN

WITH RandomWinners AS

(

SELECT TOP 5 *

FROM Ticket

ORDER BY NEWID()

)

SELECT *

INTO #RandomWinners

FROM RandomWinners;

IF EXISTS

(

SELECT sRace, sParty

FROM #RandomWinners

GROUP BY sRace, sParty

HAVING COUNT(CASE sRace WHEN 'W' THEN 1 END) >= 4 AND

COUNT(CASE sParty WHEN 'R' THEN 1 END) >= 4

)

SELECT *

FROM #RandomWinners;

SELECT @ROWS = @@ROWCOUNT;

DROP TABLE #RandomWinners;

END

Note that I have completely ignored political correctness w.r.t. supporting a lottery that seems to favor white republicans, on the basis that help on this forum is color blind.