-- RAND is not evaluated once per query in SQL 2005
SELECT Column1, Column1
     FROM (
           SELECT RAND() Column1
           FROM (
           SELECT 1 c
           UNION
           SELECT 2 c
                 ) s
           ) t