I am building a bespoke e-commerce site in SQL Server and I need some advice on the best way to set up a table to hand categories and unlimited levels of sub categories.
I have seen this article:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
BUT that is MYSQL and not...