Hello,
I have a table with product codes, and based on the product codes I need to create product hierarchy:
The codes are as below:
Level 1: 10100 – Enamel
Level 2: 1010001010 – S H E
Level 3: 101000101010101010 – Whites
Level 3: 101000101010101020 – Colors
Level 3: 101000101010101040 – Tinted Bases
Level 2: 1010001020 - SuperLac Satin Finish
Level 3: 101000102010102010 – Whites
Level 3: 101000102010102020 – Colors
Level 3: 101000102010102040 - Tinted Bases
and so on.....
All these codes are in the same table and same field but need to be bifurcated based on the code.
Need need GUYS!!
