Repeat a set of values per another column generated
I've one table that a want to generate some that the stores a set of states by a key (another column).
i.e. to each new key generated I want to insert 4 states, e,g,
Key | Value
1 | 1
2 | 1
so I need to generate 200.000 keys with 4 states, a total of 800.000 rows. I know how to do it using T-SQL, but because it's the table has other columns that I need to generate I want to use the data generator and use this generation as part of a project.
As a general question: How can I generate new columns implementing rules that depend on other columns in the same Table?
Thanks very much, Luis