Two tables one header, one lines need lines refer to header

The simplest way to populate your database with test data.

Two tables one header, one lines need lines refer to header

Postby icecurtain » Mon Dec 03, 2012 6:27 pm

Hi I'm fairly new to Data generator, so if this is a silly easy question - sorry for that, but I can't find an answer on my own.

(aim create 1,000 header rows, 10,000 line rows)
Two tables one header, one lines
Header has InvoNo, Number of lines easy to create (InvoNo 1 - 100000, Number lines always =10)

I need to create lines table data

So there are 10 created lines for each invono.

I Created header table first I can use InvoNo as foriegn key then repeat value between 1 and 10 it only create 5523 line rows.
How is it done?
icecurtain
 
Posts: 10
Joined: Mon Jan 18, 2010 6:11 pm

Postby icecurtain » Tue Dec 04, 2012 10:10 am

Found the answer, it is to use between 10 and 10 not 1 and 10 sorted, a night sleep clears the mind.
icecurtain
 
Posts: 10
Joined: Mon Jan 18, 2010 6:11 pm


Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron