Get children of a parentID

• hayekmichel

  SSC Enthusiast

  Points: 156

  More actions

  October 2, 2016 at 8:58 am

  #330712

  Hello,

  I have a table with the following structure:

  MenuID(int) Menu(varchar) ParentID(int)

  How do get all children nodes of a given MenuID even the sub nodes

  Thanks

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  October 2, 2016 at 9:39 am

  #1904307

  Please have a look at this link and see whether you may be able to adapt it to your situation.

  What you are probably looking for is a 'recursive CTE'.

  ---

• hayekmichel

  SSC Enthusiast

  Points: 156

  More actions

  October 2, 2016 at 1:07 pm

  #1904313

  Thank you so much.

  That solved it