Red Gate forums :: View topic - Two tables one header, one lines need lines refer to header
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

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

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
icecurtain



Joined: 18 Jan 2010
Posts: 10

PostPosted: Mon Dec 03, 2012 6:27 pm    Post subject: Two tables one header, one lines need lines refer to header Reply with quote

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?
Back to top
View user's profile Send private message
icecurtain



Joined: 18 Jan 2010
Posts: 10

PostPosted: Tue Dec 04, 2012 10:10 am    Post subject: Reply with quote

Found the answer, it is to use between 10 and 10 not 1 and 10 sorted, a night sleep clears the mind.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group