just thought i'd point out that with NEWID() in the SELECT clause, every row returned will be distinct, so you don't need the DISTINCT keyword