Skip to content

Instantly share code, notes, and snippets.

@IronistM
Created November 17, 2013 14:24
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save IronistM/7513985 to your computer and use it in GitHub Desktop.
Save IronistM/7513985 to your computer and use it in GitHub Desktop.
set RecCount = 500000000; // Number of records to generate
Data:
load
chr(round(25 * rand() + 65)) & chr(round(25 * rand() + 65)) & chr(round(25 * rand() + 65)) as Customer, // Customer name between AAA and ZZZ
chr(round(25 * rand() + 65)) as Product, // Product name between A and Z
round(3 * Rand() + 2008) as Year, // Year between 2008 and 2011
round(1000000 * Rand()) as Actual, // Actual Revenue between 0 and 1,000,000
round(1000000 * Rand()) as Target // Target Revenue between 0 and 1,000,000
autogenerate(RecCount);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment