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

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

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 2

Who is online

Users browsing this forum: No registered users and 0 guests