Red Gate forums :: View topic - Any way to generate an int column based on another?
Return to www.red-gate.com RSS Feed Available

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

Any way to generate an int column based on another?

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
lpcaustin



Joined: 04 Jun 2010
Posts: 1

PostPosted: Fri Jun 04, 2010 3:45 pm    Post subject: Any way to generate an int column based on another? Reply with quote

I have a column for inventories that must be based off another column. For intstance, can I create a column (column Y) that is based off another column (column X). i.e. Column X = Column Y + <some random value>.

Is this possible?
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Mon Jun 07, 2010 8:16 am    Post subject: Reply with quote

Unfortunately, you cannot generate data based on another column with SQL Data Generator out of the box. However, if you can write code, you can write your own generator. Please see the following article:

http://www.simple-talk.com/content/article.aspx?article=697
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