Posted by Khafancoder on 05/24/07 02:03

Hi guys,
in my db i have these three tables

1.Stores 2.Products 3.Parts


their structure is something like :


Stores ----> Products ----> Parts


Stores
----------------
StoreId, StoreName


Products
----------------
ProductId, StoreId, ProductName


Parts
----------------
PartId, ProductId, PartName



now, in my application i wanna to implement a bulk-copy operation so
user can copy products from one store to another one and when a
product copied to new store;

all of it's parts should copy too.
in fact i need a method to insert a Product item in Products table and
synchronously copy it's parts into Parts table and repeat this steps
until all of proucts copied.

how can i do that without cursors or loops ?


Thanks

• Next in forum: Re: Rants. Difficulty to learn ETL tools?
• Prev in forum: Re: Finding values containing milli seconds!
• Thread view: Synchronous Bulk-Copy into two table

[Reply to this message]