As a user i want to be able to select rows from one table to be able to use data from that table in the insertion

tbayart / sql-server-data-producer

Automatically exported from code.google.com/p/sql-server-data-producer

0 stars 0 forks source link

As a user i want to be able to select rows from one table to be able to use data from that table in the insertion #137

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

Add possibility to run select statements from which i can pick data from when 
generating values.

Original issue reported on code.google.com by a03pe...@gmail.com on 20 Dec 2012 at 11:21

GoogleCodeExporter commented 9 years ago

Don't know this is covered but...

As a user I would like to populate one table with one query (multiple rows).

Original comment by i...@spirit-of-stockholm.se on 22 Feb 2013 at 12:57

GoogleCodeExporter commented 9 years ago

The idea of this user story was to be able to write a query to pick up a single 
column with values to be used for the generation of *one* column. 

For example a scenario when you have logical foreign keys, you would write a 
select statement to pick up items from the logical parent and use those in the 
child.

What you are seeking is a INSERT INTO table(<columns>) SELECT <columns> FROM 
otherTable. This be added as another another user story.

Original comment by a03pe...@gmail.com on 22 Feb 2013 at 1:20

GoogleCodeExporter commented 9 years ago

This *can* be added as another user story.

Original comment by a03pe...@gmail.com on 22 Feb 2013 at 1:21