bad_query_80374.sql

WITH    rando
          AS ( SELECT   1 + ABS(CHECKSUM(NEWID())) % ( 4 ) AS RandomNumber
               FROM     master.dbo.spt_values sv
               WHERE    sv.type = 'P'
                        AND sv.number < 4
             )
    SELECT  r.RandomNumber ,
            d.number
    FROM    rando AS r
            INNER JOIN master.dbo.spt_values d ON r.RandomNumber = d.number
    WHERE   d.type = 'P'

working_version.sql

WITH    rando
          AS ( SELECT   TOP 4 1 + ABS(CHECKSUM(number)) % ( 4 ) AS RandomNumber
               FROM     master.dbo.spt_values sv
               --WHERE    sv.type = 'P'
               ORDER BY NEWID()
             )
    SELECT  r.RandomNumber ,
            d.number
    FROM    rando AS r
            INNER JOIN master.dbo.spt_values d ON r.RandomNumber = d.number
    WHERE   d.type = 'P'