Any way to generate an int column based on another?

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Any way to generate an int column based on another?

Postby lpcaustin » Fri Jun 04, 2010 3:45 pm

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?
lpcaustin
 
Posts: 1
Joined: Fri Jun 04, 2010 3:33 pm

Postby Linda Hawksworth » Mon Jun 07, 2010 8:16 am

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/arti ... rticle=697
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests