USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_SMARTQUERIES

                CREATE procedure [dbo].[USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_SMARTQUERIES]
                (
                    @SYSTEMROLEID uniqueidentifier,
                    @ONLYASSIGNED bit = 0
                )
                /* Used by the SecurityGetRoleFeaturePermTreeRequest web service */
                as
                set nocount on;

                if @SYSTEMROLEID is null
                begin
                    raiserror('@SYSTEMROLEID is required',16,10);
                    return 7;
                end;

                select
                    [CATALOG].ID,
                    [CATALOG].NAME,
                    [CATALOG].SECURITYUIFOLDER,
                    [PERM].GRANTORDENY,
                    [CATALOG].DESCRIPTION,
                    [PERM].ID as [PERMISSIONID],
                    [CATALOG].SMARTQUERYSPEC as SPECXML
                from 
                    dbo.SMARTQUERYCATALOG as [CATALOG]
                left outer join
                    (
                        select 
                            ID, 
                            GRANTORDENY, 
                            SMARTQUERYCATALOGID 
                        from 
                            dbo.SYSTEMROLEPERM_SMARTQUERY
                        where 
                            SYSTEMROLEID = @SYSTEMROLEID
                    ) as [PERM] on [PERM].SMARTQUERYCATALOGID = [CATALOG].ID
                where 
                    ([PERM].ID is not null) or (@ONLYASSIGNED = 0)
                order by 
                    [CATALOG].SECURITYUIFOLDER, [CATALOG].NAME;