USP_DATALIST_SECURITY_CONSTITSECURITYGROUP_NAVIGATIONTREE

                CREATE procedure dbo.USP_DATALIST_SECURITY_CONSTITSECURITYGROUP_NAVIGATIONTREE
                as

                set nocount on;

                select 
                    NAME as CAPTION,
                    'RES:database_n_keys' as IMAGEKEY,
                    CAST('324973C4-F822-4863-A340-16C3A88D781D' AS UNIQUEIDENTIFIER) as PAGEID, 
                    CAST(ID AS NVARCHAR(36)) as CONTEXTID,                    
                    (
                        select distinct
                            SYSTEMROLE.NAME as CAPTION,
                            'res:usersfolder' AS IMAGEKEY,
                            cast('b0c3a779-0eb7-44d9-970c-f17d5bc94fa1' as UNIQUEIDENTIFIER) as PAGEID, 
                            CAST(SYSTEMROLE.ID AS NVARCHAR(36)) as CONTEXTID                        
                        from 
                            dbo.SYSTEMROLEAPPUSERCONSTITUENTSECURITY 
                            inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEAPPUSER.ID = SYSTEMROLEAPPUSERCONSTITUENTSECURITY.SYSTEMROLEAPPUSERID
                            inner join dbo.SYSTEMROLE on SYSTEMROLE.ID = SYSTEMROLEAPPUSER.SYSTEMROLEID
                        WHERE 
                            SYSTEMROLEAPPUSERCONSTITUENTSECURITY.CONSTITUENTSECURITYATTRIBUTEID = CONSTIT_SECURITY_ATTRIBUTE.ID                        
                        ORDER BY 
                            [NAME]                        
                            for xml raw('NODE'), elements, type,root('NODES')
                    ) as NODES                    
                from
                    dbo.CONSTIT_SECURITY_ATTRIBUTE 
                ORDER BY 
                    CONSTIT_SECURITY_ATTRIBUTE.NAME