Please rate this item: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Product Category Hierarchy (with Breadcrumb Trail) using CTE query

The example query below creates a product category table and populates it with sample data. I then use a CTE query to return the categories, along with the breadcrumb trail (lineage)

Updated: Monday, 14th September, 2015 — 2:25 pm

Leave a Reply

Your email address will not be published. Required fields are marked *

CJayMead's SQL Server, Endeca, MS Office Help © 2018