What are the challenges you face when working across database platforms? Take the survey
Options

Help with generating data for country table

glozanomoranglozanomoran Posts: 2
edited January 13, 2015 11:47AM in SQL Data Generator
Hello

I did not know how to choose a good title for this topic but let me explain what I am trying to accomplish. We have a country table with the following columns:

- ID
- CountryCode (ISO 3166-1 alpha-2)
- CountryCode (ISO 3166-1 alpha-3)
- NAME

The problem is that per row random data is being generated that are not related. For example we should have a row:

1 - BE - BEL - BELGIUM

But instead we get for each column random data:

1 - ES - POR - CAMEROON

Is there a way to ensure that the generated data is somehow related per row?

Thx

Comments

Sign In or Register to comment.