Here's the deal: I have a database with table called Categories. Categories has a parent-child relationship in them. Here's what the table looks like (exluding stuff not related to the problem ...

The relationship table holds details of the n:m relationships between the other two, i.e. just a problem id and a service id. In a stored procedure, I'm returning a subset of problem records but I ...