Hi, thanks!

I'm not sure what all your columns mean, could you elaborate?

Also, with your example, when vendor A writes a testimonial for vendor B, and later vice versa...how would I...

I liked the non-duplicate solution

This looks awesome! 🙂

2 questions:

1. how can I narrow this query to show only the categorystring for a single product, e.g. "2481445"?

2. If I ever add more levels to my...

Ok, I did that now 🙂

Let me know if this works and if not what errors you're getting. btw: This script was generated using MSSQL Management Studio.

Cool! I ran it directly, but I get some weird results:

2481445taarttoppers > taarttoppers > taarttoppers > taarttoppers > taarttoppers > taarttoppers > grappig > grappig > grappig > grappig >...

Thanks again. I really need just SQL and not stored procedures as I want to use the SQL in my Solr data-config.xml which does not support stored procedures. My bad,...

@jason: Thanks. But your query returns 552 rows for the few products I have and for the resulting rows that have a value for artikelid the artikelgroups are...

That'd be awesome! I can wait now I now a solution is nearby. Great to have experts look over my shoulder at this 🙂

Thanks!

.

Correct.

If you just have one ultimate parent named "All Categories", you can have a normal hierarchy that can be easily navigated with traditional techniques. You...

Ahhh... okay... If I had my druthers, I'd be setting up a Product table, a Categories table, and then the mapping table would just have a Product ID and a...

@Lynn: this looks great already! Thanks!

I now see that this groups all article groups, independent of the productid...how would I alter this query to return only the...

Thanks for your reply.

Actually there's no real overlap as far as I can see, except in the naming of the categories, but the actual categoryid as a node always...

I did not explain it correctly: the main problem is not creating a comma delimited string, the main problem is how to concatenate data from different levels in a hierarchical...

Thanks everyone!

Paging is indeed done at the presentation layer, however, I want to only return the data for the current page and not ALL results.

How other of my SQL statements look...