Red Gate forums :: View topic - Creating sequence of Monthly Entries
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

Creating sequence of Monthly Entries

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



Joined: 29 Jan 2013
Posts: 2

PostPosted: Wed Jan 30, 2013 6:23 pm    Post subject: Creating sequence of Monthly Entries Reply with quote

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.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Thu Jan 31, 2013 11:13 pm    Post subject: Reply with quote

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
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