Heres How to Generate lots of data from a tiny table - maybe you already know this

• bobsterboy

  SSCommitted

  Points: 1539

  More actions

  September 9, 2004 at 12:21 am

  #60213

  I was doing some time trials today and couldn't get enough data to really "hurt" the procedure, so I hit upon the Cross Join functionality.

   

  Say you want a million+ records and your biggest testing table has only 1000.

  All you have to do is Cross Join it to itself and you get 1000² or a million rows^, cross join it again and you end up with a billion records

  For example:

  tblTest has 200 rows.   You want 8,000,000 (funny how it worked out)

  Select * from tblTest, tblTest as test1, tblTest as Test3

  You end up with 8 million records, all from 200!

   

   

• September 13, 2004 at 8:00 am

  This was removed by the editor as SPAM