I am having a problem writing a SQL query...
I have a table named Categories with the following fields:
I need to be able to pass the Category ID a retrieve it's path in the following format
Where Vehicle is the top level category and Sedan is the bottom level with the category ID that was passed. ParentCategoryID establishes the relationships between the various categories.