Recursive query

Posts   
 
    
Posts: 87
Joined: 17-May-2011
# Posted on: 31-Jan-2012 15:35:30   

Hi There

I have a scenerio where I need to get a message and it's children and children's further children branches. Eg : MessageId ParentMessageId 10686 NULL 10687 10686 10688 10687 10689 10688 10690 10689 10691 10690 10692 10686

Here above if I pass 10686 it should return me 10686 10687 10688 10689 10690 10691 10692 What will be the best approach to do that???

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 01-Feb-2012 00:28:46   

There are various methods in which you can achieve this. To read about the discussions/solutions please follow this thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=9976&StartAtMessage=0&#55488

David Elizondo | LLBLGen Support Team