The MobileApplicationID and CustomerID identify the collection of rows that make up a specific tree. The level of each row within a specific tree is determined by the ParentID of each...

Hi I'm really sorry about not replying sooner - I forgot this thread!

It was indeed a precision issue - the SELECT was returning...

One small fix to the sp, as MobileApplicaitonID and CustomerID are required on the parents as well as the child:

CREATE PROCEDURE dbo.uspMobileApplicationReportMenu

(

            @MobileApplicationID...

Hi - many thanks for the reply.

This isn't quite what I was looking for however - I need the child row to be...

So if you run all that code you can test with this:

MobileApplicationReportMenu '5b1d4e7d-759b-4599-b9eb-0acf62a78715', '4092148d-beac-40ee-8057-90d542feb94d'

Sure, it's pretty trivial. Since it's so messy to write out i've only included 2 rows - a child and it's parent.

At the moment the "top" parent row has a '000....'...

Hi, could you explain again please? I can't quite understand what you are saying.

I expect DISTINCT to return rows that are unique... my question is why is this not happening?...

Oh I forgot to mention... RGCcache has about 10 rows of varying types, but I can't see this as being relevent.