Re: Recursive CTE for building menus

2018-04-13 Thread Tim Smith
On 13 April 2018 at 16:04, Paul Jungwirth wrote: > On 04/13/2018 02:09 AM, Bob Jones wrote: >> >> The adaptions I am trying to make are as follows: >> - Higher priority moves the item higher up the menu (i.e. adapting >> from the original "votes" concept). >> - Default alphabetical ordering of tit

Re: Recursive CTE for building menus

2018-04-13 Thread Paul Jungwirth
On 04/13/2018 02:09 AM, Bob Jones wrote: The adaptions I am trying to make are as follows: - Higher priority moves the item higher up the menu (i.e. adapting from the original "votes" concept). - Default alphabetical ordering of titles - Use of alphanumeric IDs instead of numeric Hi, I wrote th