UFN_SYSTEMROLE_GETKPILIST

            create function dbo.UFN_SYSTEMROLE_GETKPILIST
            (
                @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].KPICATALOGID,
                    [SRP].GRANTORDENY
                from dbo.SYSTEMROLEPERM_KPI as [SRP]
                where [SRP].SYSTEMROLEID = @SYSTEMROLEID
            )