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:17 am

    #1464182

    Krtyknm (3/26/2012)

    Hi Jeff,

    Nice Article, Keep going.

    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.

    Thanks,

    Karthik

    They can use virtually any table. Any table with just 1000 rows will allow them to build a million row table using the Cross Join.

    That, notwithstanding, in such situations and like I said in the article, I'll build a Tally table for them. My Tally tables usually have 11000 rows in them so I can use it to build 30 years of dates. That's enough for a Cross Join to build a million rows... or 121 million if they want. 🙂

    --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)