Avatar of intelliflex
Flag for United States of America

asked on 

Categories/Sub-Categories - Best Performance? (ASP.NET / SQL)

What is the best design for SQL data tables for Categories, Unlimited Sub-Categories, and Products? Some products will be in multiple categories. Also, what would be the best way to pull them out, Stored Procedures? Example code? (this will be for a classified ads website)
Thanks for your time, it is very much appreciated!
Microsoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon