Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Generating Test Data: Part 1 - Generating Random Integers and Floats RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

  • March 26, 2012 at 6:20 am

    #1464184

    paul.knibbs (3/26/2012)

    Krtyknm (3/26/2012)

    I have a question on sys tables, most of them using the Sys.tables for generating random numbers. Assume that developers don't have an access to System tables, then how can they get the random numbers.

    He's only using a system table (or view, strictly speaking) because of the number of rows it has--any table with a decent number of rows will work, whether it's a tally table or one of your main data tables.

    Ah... I should have scrolled down a bit more before replying. Thanks for the cover, Paul!

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)