I have tried to use the dynamic menu SQL example on the Power CMS forum with little success.
I assume from this you mean the following SQL:
SELECT C2.ContentGroup, C2.ContentPageSetOrder
FROM pcms2_contents AS C1 LEFT OUTER JOIN pcms2_contents AS C2
ON C2.ContentPagesetParentID = C1.ContentID
WHERE C2.ContentPageSetOrder IS NOT NULL
GROUP BY C2.ContentPageSetOrder
ORDER BY C2.ContentPageSetOrder DESC
for your needs, you will probably need to modify the select statement to include the contentValue and ContentPageName columns as well:
SELECT C2.ContentGroup, C2.ContentPageSetOrder, C2.ContentValue, C2. ContentPageName
FROM pcms2_contents AS C1 LEFT OUTER JOIN pcms2_contents AS C2
ON C2.ContentPagesetParentID = C1.ContentID
WHERE C2.ContentPageSetOrder IS NOT NULL
GROUP BY C2.ContentPageSetOrder
ORDER BY C2.ContentPageSetOrder DESC
if that is not working for you, please describe the results you are getting using that SQL versus the results you are expecting so i can have a better idea of the problem.