Generating data based on another table
I am new to Sql Data Generator. I have two tables which are related via a foreign key. For each row in the parent table, I want to create 12 rows in the child table (one for each month). So, my child table has a date field in it and I want 12 rows (one row for the first day of each month in the year.) What is the best generator to use to do this. I cannot figure out how without getting duplicates. Can you give me some tips here? Thanks in advance.
0 · Share on Twitter