Home Forums SQL Server 2008 T-SQL (SS2K8) Top Randomized Results with Multiple Qualifying Conditions RE: Top Randomized Results with Multiple Qualifying Conditions

  • September 24, 2013 at 2:10 pm

    #1652884

    I get a different random number every time I reference the CTE ?!?!

    SELECT l1.ticketID, l1.iRandom, l2.iRandom FROM lottery l1 INNER JOIN lottery l2 ON l1.TicketID = l2.TicketID

    Well, I guess I will need to use a temp table