Find All Children Of A specified Group ID

Hi all, Im designing a product menu like the one seenhere.
I need to be able to itterate through all product menu groups in a table and find all children of a specified parent. Sorry for the cryptic Explanation and crappyDiagram!

Please see mydiagramWhat does you table(s) look like? Can you post the DDL and some sample data?|||Certainly.

Here you go.|||Have you ever looped through all directories on a drive, folder by folder by coding a function that searches all subdirectories of a single directory and calls itself on each directory that it finds?

This is what im trying to achieve here, only by using stored procedures.|||>>Have you ever...

Sure. Here are some links which should get you on your way.

http://www.sqlteam.com/item.asp?ItemID=8866
http://www.intelligententerprise.com/001020/celko1_1.jhtml?_requestid=57013|||Nice one, Ta very much indeed!