Please help in my application!!!

Eteleeb

New member
Joined
Apr 6, 2005
Messages
4
Programming Experience
Beginner
Hi Guys
I have small problem with my application, please if someone can help. my story is that I have the following table:
Dim1Dim2Dim3Dim4TimestoreproductcustomerTimestoreproductNULLTimestoreNULLNULLTimeNULLNULLNULLNULLNULLNULLNULLNULLstoreproductcustomerNULLstoreproductNULLNULLstoreNULLNULLTimeNULLproductcustomerNULLNULLproductcustomerNULLNULLproductNULLTimestoreNULLcustomerTimeNULLNULLcustomerNULLNULLNULLcustomerTimeNULLproductNULLNULLstoreNULLcustomer


the table is showing all possible combinations of foure dimensions: Product, Store, Time, Customer. each row in my table is representing an element. so now I have another table consists of two columns:

Element_name

Element_parent







now I want to insert each element(Row) from the first table into the element_name in the second table and insert all its parent elements.
for example:
element:(Product,time,Store,null) is the parent of (Product,Time) ,(Product,store) ,(time,store) ,(Product) ,(Time) and (Store). Null values are not mentioned in the example. for sure the top element that has no null values is the parent of all of them and the element that has only NULL's in the four columns is the smallest child.
Therefore, please can someone come up with the code that can insert do this process.
I will appreciate any help.
Eteleeb
 
Top Bottom