Creating sequence of Monthly Entries
lukemmiller
Posts: 4 New member
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:
Employee.GoToFirst
While .not Employee.EndOfFile do
For i = 2010 to 2012
For j = 1 to 12
Review.Add
Review.EmployeeID = Employee.ID
Review.Year = i
Review.Month = j
Next j
Next i
Employee.Next
End While
How would I do that with the Data Generator? TIA.
So I have two tables, employee and reviews. In psuedo-code I would do something like:
Employee.GoToFirst
While .not Employee.EndOfFile do
For i = 2010 to 2012
For j = 1 to 12
Review.Add
Review.EmployeeID = Employee.ID
Review.Year = i
Review.Month = j
Next j
Next i
Employee.Next
End While
How would I do that with the Data Generator? TIA.
Comments
There is an existing feature request for this capability with reference number SDG-682.
Product Support
Red Gate Software