UFN_SYSTEMROLE_GETSMARTQUERYLIST

            create function dbo.UFN_SYSTEMROLE_GETSMARTQUERYLIST
            (
                @SYSTEMROLEID uniqueidentifier
            )
            /*Returns a table of IDs for all of the smart queries that have been assigned to the given SYSTEMROLEID.*/
            returns table
            as
            return
            (
                select
                    [SRP].ID,
                    [SRP].SMARTQUERYCATALOGID,
                    [SRP].GRANTORDENY
                from dbo.SYSTEMROLEPERM_SMARTQUERY as [SRP]
                where [SRP].SYSTEMROLEID = @SYSTEMROLEID
            )