Creating sequence of Monthly Entries

The simplest way to populate your database with test data.

Creating sequence of Monthly Entries

Postby lukemmiller » Wed Jan 30, 2013 5:23 pm

I am trying to create a demo database for employee evaluations. Each employee gets 1 evaluation per month. I want to create evaluations for every month from 2010 to 2012.

So I have two tables, employee and reviews. In psuedo-code I would do something like:

While .not Employee.EndOfFile do
For i = 2010 to 2012
For j = 1 to 12
Review.EmployeeID = Employee.ID
Review.Year = i
Review.Month = j
Next j
Next i
End While

How would I do that with the Data Generator? TIA.
Posts: 2
Joined: Tue Jan 29, 2013 7:02 pm

Postby Manfred.Castro » Thu Jan 31, 2013 10:13 pm

Unfortunately it is not currently possible to generate data based on data that has been/will be generated in another table/column.
There is an existing feature request for this capability with reference number SDG-682.
Manfred Castro
Product Support
Red Gate Software
Posts: 209
Joined: Mon Apr 23, 2012 1:49 pm

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests