Hello all,
I'm working on webshop database consisting of these tables:
customers, customers_groups, products_groups, products
For every customer (in customers) there is an entry in customers_groups.
The price lists that are used for every customer are defined in the table products_groups.
In products_groups the ids of customers_groups and products are used to assign a special price to every group.
Now I would like to insert data from another db on the sqlserver that holds the customer and product information.
So I have to insert price entries for all products for each customer.
I working on some t-sql procedures that should do that job.
In pseudo code:
FOR EACH product
INSERT INTO products_groups (, ...price)
END FOR
END FOR
Would that be a cross join
Thanks in advance for every hint!