Fun with RAND()

• Dave62

  SSCertifiable

  Points: 6398

  November 4, 2014 at 9:51 pm

  #312690

  Comments posted to this topic are about the item Fun with RAND()

• Koen Verbeeck

  SSC Guru

  Points: 258928

  November 5, 2014 at 1:09 am

  #1756671

  Great question, thanks.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• November 5, 2014 at 1:18 am

  This was removed by the editor as SPAM

• RKaram

  SSCommitted

  Points: 1518

  November 5, 2014 at 3:26 am

  #1756689

  Smart question :-):-)

  thank you Dave

  rabih

  rkaram

• palotaiarpad

  SSCarpal Tunnel

  Points: 4881

  November 5, 2014 at 4:52 am

  #1756706

  I hate myself not to read the relation correctly! 😀

• SqlMel

  SSCrazy

  Points: 2891

  November 5, 2014 at 5:04 am

  #1756709

  Very good question. Thanks.

  I almost got it wrong but I realized in time that the loop had a "<" and not "<="

  ---------------
  Mel. 😎

• Ed Wagner

  SSC Guru

  Points: 286958

  November 5, 2014 at 5:05 am

  #1756710

  SqlMel (11/5/2014)

  ---

  Very good question. Thanks.

  I almost got it wrong but I realized in time that the loop had a "<" and not "<="

  That's what got me. Need more coffee.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• alvertorave

  Newbie

  Points: 9

  November 5, 2014 at 6:17 am

  #1756733

  I think the answer is wrong, you can only have 1 row, but you can execute the select 0 to 9 times returning a single row.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  November 5, 2014 at 6:32 am

  #1756738

  Nice question, thank you.

• freeheel

  SSCrazy

  Points: 2404

  November 5, 2014 at 7:09 am

  #1756751

  alvertorave (11/5/2014)

  ---

  I think the answer is wrong, you can only have 1 row, but you can execute the select 0 to 9 times returning a single row.

  my thought exactly. i got it right, but ...

• Brian.Klinect

  Mr or Mrs. 500

  Points: 592

  November 5, 2014 at 7:16 am

  #1756752

  I forgot RAND() was exclusive. So we can get .99999..., which multiplies to 9.999999..... I take it then that storing a floating point number as an integer just truncates in SQL?

• stephen.long.1

  SSCrazy

  Points: 2568

  November 5, 2014 at 7:21 am

  #1756753

  Nice question, Dave, and a good explanation. Thanks!

• Dana Medley

  SSCertifiable

  Points: 6764

  November 5, 2014 at 7:21 am

  #1756754

  Ed Wagner (11/5/2014)

  ---

  SqlMel (11/5/2014)

  ---

  Very good question. Thanks.

  I almost got it wrong but I realized in time that the loop had a "<" and not "<="

  That's what got me. Need more coffee.

  Almost got me too. Thanks for the question.

  ---

  
  Everything is awesome!

• david.gugg

  SSCertifiable

  Points: 5624

  November 5, 2014 at 7:22 am

  #1756755

  Fun questions, thank you.

  
  [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
  [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

• Mike Hays

  SSCommitted

  Points: 1871

  November 5, 2014 at 7:52 am

  #1756759

  Interesting Question, I ran it a couple of time to see the different results...