Random unions

• anthony.albutt 468

  SSC Veteran

  Points: 212

  More actions

  October 24, 2014 at 3:46 am

  #1754573

  SELECT

  RAND(100)

  , RAND(7)

  , RAND()

  UNION ALL

  SELECT

  RAND(100)

  , RAND(7)

  , RAND()

  UNION ALL

  SELECT

  RAND(100)

  , RAND(7)

  , RAND()

  ;

  go

  returns

  ---------------------- ---------------------- ----------------------

  0.715436657367485 0.713703791040473 0.945719735396816

  0.715436657367485 0.713703791040473 0.945719735396816

  0.715436657367485 0.713703791040473 0.945719735396816

  (3 row(s) affected)

  Why, it is not supposed to ??

• SQLWinther

  SSCertifiable

  Points: 6294

  More actions

  October 26, 2014 at 5:26 pm

  #1754822

  TomThomson (10/23/2014)

  ---

  Amusing question; the use of RAND is an interesting distraction for a question that is really about UNION ALL and nothing else.

  I agree! It would have been UNION instead of a UNION ALL to make it less obvious.

  /Håkan Winther
  MCITP:Database Developer 2008
  MCTS: SQL Server 2008, Implementation and Maintenance
  MCSE: Data Platform

• Andre Ranieri

  SSCrazy

  Points: 2819

  More actions

  January 26, 2015 at 3:26 pm

  #1773249

  Thanks for the question.