Any way to generate an int column based on another?

[lpcaustin]

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?

[Linda Hawksworth]

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