I have the categories of a website structured in my database like this:
HOME|Electronics|Printers
HOME|Electronics|Fax Machines
HOME|Electronics|Scanners
HOME|Outdoor|Tents
HOME|Outdoor|Hiking
HOME|Outdoor|Biking
HOME|Outdoor|Athletic
Now I want to connect it to a software that maps to treeview, the problem is that it expects the table to be structured in this way:
1 HOME
2 Electronics
3 Printers
4 Fax Machines
5 Scanners
6 Outdoor
7 Hiking
8 Biking
9 Athletic
Is it possible to convert from one to the other in SQL? Keeping in mind that main categories (like Electronics) will repeat & I want to make sure that they all get the same index.
I can also do it in another language, but it just seems like it could/should be capable in SQL only.